nara krishna kanth

Part 52 Database normalization

Part 32 Multi statement table valued functions in sql server

Part 14 Self join in sql server

Part 65 List all tables in a sql server database using a query

Part 67 Alter database table columns without dropping table

Part 26 IsDate, Day, Month, Year and DateName DateTime functions in SQL Server

Part 30 Scalaruser defined functions in sql server

Part 3 Creating and working with tables

Part 24 Replicate, Space, Patindex, Replace and Stuff string functions in sql server 2008

Part 44 Afterupdate trigger 2

Part 68 Optionalparameters in sql server stored procedures

Part 10 Select statement in sql server

Part 48 Derivedtables and common table expressions in sql server

Part 69 Merge in SQL Server

Part 36 Clusteredand nonclustered indexes in sql server

Part 47 Insteadof delete triggers in sql server

Part 22 Builtin string functions in sql server 2008

Part 12 Joins in sql server

Part 11 Group by in sql server

Part 62 What to choose for performance SubQuery or Joins

Part 13 Advanced or intelligent joins in sql server

Part 33 Important concepts related to functions in sql server

Part 34 Temporary tables in SQL Server

Part 43 DMLtriggers in sql server

Part 15 Different ways to replace NULL in sql server

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

Part 50 Updatable common table expressions in sql server

Part 18 Storedprocedures in sql server

Part 20 Storedprocedure output parameters or return values

Part 31 Inline table valued functions in sql server

Part 29 Mathematicalfunctions in sql server

Part 19 Storedprocedures with output parameters

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

Part 52 Database normalization

Part 25 DateTime functions in SQL Server

Part 56 Errorhandling in sql server