I have tried to search from the web resources for SQL Server programming. Basically I'm trying to search good tutorial for programming SQL Server (creating procedures, triggers, cursors etc.). Can you give some helping hand and show some links for good tutorials?
Start with MSDN: http://msdn.microsoft.com/en-us/sqlserver/default.aspx as there's a wealth of info on there. Also, for specific syntax/queries I find Pinal Dave's blog to be essential: http://blog.sqlauthority.com/
http://www.sql-server-performance.com is a great place to start.