SQL Knowledge Base

A collection of links to useful and oft-forgotten SQL info:

• Getting the last inserted key (identity):
  http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/
• T-SQL FOR XML Basics:
  http://blah.winsmarts.com/2007-2-Bak2Basics__Learn_T-SQL_-_FOR_XML.aspx
• T-SQL XML Crib-sheet:
  http://www.simple-talk.com/sql/learn-sql-server/sql-server-xml-cribsheet/#fourth
• Robyn Page's SQL Articles:
  http://www.simple-talk.com/author/robyn-page/
• Never do this- Validating a URL in SQL:
  http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/validate-a-url-from-sql-server.aspx
• Reading XML files into table fields:
• http://stackoverflow.com/questions/3245301/using-t-sql-to-read-an-xml-feed-directly-into-an-xml-field-in-a-table
• SSIS XML Import tutorial video:
  http://msdn.microsoft.com/en-us/library/cc952927(SQL.100).aspx
• Processing XSLT in SQL Server:
  http://blogs.msdn.com/b/mrorke/archive/2005/06/28/433471.aspx
• Numbering Rows:
  http://blogs.x2line.com/al/archive/2005/11/18/1323.aspx
• Rollbacks:
  http://www.geekinterview.com/question_details/33247
  http://msdn.microsoft.com/en-us/library/aa175920(SQL.80).aspx