All About SQL Functions
Monday, December 17th, 2007SQL: Functioning in the Real World
Monday, December 10th, 2007A couple of months or so ago I began talking about SQL functions and what they re used for. This article picks up where I left off. It defines the two types of functions and begins to explain them in great detail.... Refurbished and Used Networking Equipment Network Liquidators ...
More Advanced SQL Statements
Monday, October 8th, 2007In this third part to a series on beginning SQL you ll learn how to use SQL statements to manipulate entire tables to join them alter them and even delete them. It s all part of keeping a firm grip on your databases. Keep reading to ...
The Unexpected SQL Injection
Saturday, September 29th, 2007Alexander Andonov (Mordred) has written an articled called The Unexpected SQL Injection for the Web Application Security Consortium: We will look at several scenarios under which SQL injection may occur, even though mysql_real_escape_string() has been...
Beginning SQL the SEQUEL: Working with Advanced SQL Statements
Wednesday, September 26th, 2007So you made it through the first tutorial and now you are back for more. Well buckle up for the ride because this episode teaches you the glories of advanced SQL statements. By the end of this article you ll be able to sort data join data ...
Beginning SQL
Tuesday, September 25th, 2007It s great to have information organized in a database but what do you do with it once it s in there The answer is that you have to get it out again before you can do anything with it. And that s where Structured Query Language ...
How to Use the Oracle SQL Developer Tool
Wednesday, February 28th, 2007Now there is a standalone graphic user interface that you can use to develop your SQL with Oracle databases. The many things you do in Oracle 1 G XE can also be carried out with the Oracle SQL Developer. It is expected to enhance productivity in your Oracle applications.... Live Programming ...
Migrating from Oracle 10G XE to SQL Anywhere 10
Wednesday, July 19th, 2006In a previous article a set of tables from Oracle 1 G XE were transferred to SQL 2 5 Server using SQL 2 5 Server s Export Import Wizard. This article is about migrating a table from Oracle 1 G XE to SQL Anywhere 1 .... (Advertisement) Automate ...
SQL Script Support in Oracle 10G Express Edition
Wednesday, June 28th, 2006In an earlier tutorial we saw how to use SQL commands in the Oracle 1 g Express Edition or simply Oracle XE. We also saw how to use the PL SQL commands as well. In another tutorial we saw how to use the Query Builder the graphical interface ...
Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005
Thursday, June 22nd, 2006Many enterprises need to move data from one kind of data source to another. This tutorial guides you through the steps necessary to move data from Oracle XE into a SQL 2 5 Server database.... (Advertisement) BPM/SOA Information from IBM. Simplify complex programming tasks. Learn more with white papers and ...
SQL Performance and Tuning Considerations, concluded
Thursday, March 23rd, 2006This article the second of two parts will show you how to make the SQL statements you write run faster and more efficiently. It is excerpted from chapter 11 of the book em SQL DeMYSTiFied em written by Andy Oppel McGraw-Hill Osborne ...
Get Your Pocket PHP Reference and Help Hurricane Relief SQL Performance and Tuning Considerations
Friday, March 17th, 2006php|architect has announced the publication of php|architect's Pocket PHP Reference, a handy guide to every function in PHP, inclusive of syntax, extension and description. It's a perfect companion for all your coding work, perfect for looking up function syntax in a pinch This article the first of two parts ...
SQL Performance and Tuning Considerations
Thursday, March 16th, 2006This article the first of two parts will show you how to make the SQL statements you write run faster and more efficiently. It is excerpted from chapter 11 of the book em SQL DeMYSTiFied em written by Andy Oppel McGraw-Hill Osborne ...
