We are looking to upgrade our Intranet database from Microsoft SQL 2000 to SQL 2005. We wanted to know if we have to worry about deprecated datatypes in our coding or that should not be an issue going from 2000 to 2005?
Any assistance offered would be greatly appreciated.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …