Sql Server Quick reference : How to

How to get the version of Sqlserver ?
Step 1 :
Open query analyser and execute the following
Select serverproperty('productversion'), serverproperty('productlevel'), serverproperty('edition')

Step 2 :
If Output is 10.0.1600.22 for first field then its sqlserver 2008
If Output is 9.00.3257.00 for first field then its sqlserver 2005

For further details : http://support.microsoft.com/kb/321185

---

Common Solution for T-sql problems
'http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=SelectTopNbyGroup&referringTitle=Home

Recursive Queries Using Common Table Expressions

http://msdn.microsoft.com/en-us/library/ms186243.aspx