I’ve seen a lot of posts online over the last few weeks with people asking about basic query syntax. So over the next few posts I’m going to show some basic T/SQL queries as well as some more “advanced” features and syntaxes.
Hopefully you’ll find these syntaxes useful.
All the code syntaxes will cover SQL 2000 and SQL 2005. Where code only works in one version or another it will be noted.