Subscribe to this blog
Advice from Aunt Kathi
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, 156 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, 91 reads
Posted in Advice from Aunt Kathi on 3 January 2008