Part 48 Derivedtables and common table expressions in sql server

Part 69 Merge in SQL Server

Part 47 Insteadof delete triggers in sql server

Part 56 Errorhandling in sql server

Part 68 Optionalparameters in sql server stored procedures

Part 48 Derivedtables and common table expressions in sql server

Part 44 Afterupdate trigger 2

Part 36 Clusteredand nonclustered indexes in sql server

Part 33 Important concepts related to functions in sql server

Part 43 DMLtriggers in sql server

Part 19 Storedprocedures with output parameters

Part 30 Scalaruser defined functions in sql server

Part 29 Mathematicalfunctions in sql server

Part 20 Storedprocedure output parameters or return values

Part 22 Builtin string functions in sql server 2008

Part 18 Storedprocedures in sql server

Part 13 Advanced or intelligent joins in sql server

Part 12 Joins in sql server

Part 11 Group by in sql server

Part 10 Select statement in sql server

Part 3 Creating and working with tables

Part 8 How to get the last generated identity column value in SQL Server

Part 23 LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql server

Part 62 What to choose for performance SubQuery or Joins

Part 50 Updatable common table expressions in sql server