If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL ...

WHILE loop performance in SQL Server ... In a previous TechRepublic column about SQL Server 2005, I showed how you can convert some of your iterative queries (cursors) to set-based operations ...

SQL JOINs make it easy to find and fix missing data ... Figure B shows the results of this query. Notice that, because the WHERE clause specifies that the entries in the DonorID fields must ...