SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Advice from Aunt Kathi

Kathi Kellenberger is a Sr. Consultant with Pragmatic Works. She is an author, speaker and trainer.

Archives: January 2008

Finding missing rows

One way to find the rows from one table that don't match another table is to use a sub-query. Here is an example:

--create and populate tables
create table table1(col1 int null)
create table table2(col1 int null)

insert into table1(col1)
select 1
UNION select 2
UNION select 3

insert into table2(col1) Read more

0 comments, 511 reads

Posted in Advice from Aunt Kathi on 22 January 2008

End to End T-SQL!

After a couple of months of discussion, End to End Training has scheduled me to teach a two day beginning T-SQL course for them.  One of the best aspects of End to End Training is that the courseware is written by the trainers. It’s a lot more work to… Read more

2 comments, 452 reads

Posted in Advice from Aunt Kathi on 3 January 2008