Refer my post on Technet Wiki - http://social.technet.microsoft.com/wiki/contents/articles/18750.ssrs-multiple-ways-to-split-a-string-into-multiple-lines.aspx
SQL Server - Split delimited string into separate columns
Refer my post on Technet Gallery - http://gallery.technet.microsoft.com/scriptcenter/SQL-Server-2012-Split-bdbf6fc2
SSMS Keyboard Shortcuts
In this post , I wanted to share about SQL Server Management Studio (SSMS) Keyboard Shortcuts listed on technet article - http://technet.microsoft.com/en-us/library/ms174205%28v=sql.100%29.aspx
SQL Server System Catalog FA(Q)ueries
Here is a very useful article on MSDN , which is about frequently asked queries using SQL Server system catalog 's - http://msdn.microsoft.com/en-IN/library/ms345522%28v=sql.110%29.aspx
SQL Server - Import/Shred XML from XML file placed in a folder into table
If the requirement is to import/shred XML from XML file placed in a folder into table , then this can be done by creating stored procedure using XQUERY & OPENROWSET :
Refer my post on Technet gallery - http://gallery.technet.microsoft.com/scriptcenter/SQL-Server-ImportShred-XML-7f3baa40#content
Subscribe to:
Posts (Atom)