Sql Server 2005-Basic SQL Stuff

Hi All,
Here you can find good example of sql statements for Cursor,Triggeres,Indexes,Joins,UNIONS,Highest salary ,Having,Group By Order By,COALESCE,NOT IN,Time ‘N’ Date Format Func,TEMP table Usage,CASE statements,Split Columns,Duplicate identification.
Really Very good Stuff.
Please go through thi.
Cheers,
Rav’s
http://sqlservercodebook.blogspot.com/2008_03_01_archive.html