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 2006

Pro SSIS is Here!

My box of books arrived today!  For me, a first-time author (actually co-author), this is very surreal. I remember it was a ton of work, but I would do it all over again. 

So, if you need a good resource to learn SQL Server 2005 Integration be sure to check it… Read more

2 comments, 1,319 reads

Posted in Advice from Aunt Kathi on 25 January 2006

Cast vs Convert

Sometimes you must "convert" a column or variable from one data type to another.  For example, if you want to compare a numeric value to a string, you must often cast one to the other so that the comparison can be made.   This can be done with either CAST or CONVERT.

I've… Read more

3 comments, 1,778 reads

Posted in Advice from Aunt Kathi on 23 January 2006