Posted by SQL Enthusiast
Article by our editor
Most solutions to the problem of concatenating rows into a single string involve some sort of looping, usually using a cursor or while loop, or recursion using a Common Table Expression (CTE). This tip describes an alternative technique which uses an undocumented Microsoft feature to achieve concatenation.
Comments (1) • Read full article »
As a DBA it’s important to quickly identify any issues with SQL Server Agent jobs. This article includes a number of scripts which make it easy to identify which jobs have failed and which are still running as well as generating a history of when each job ran.
Comments (21) • Read full article »
More SQL questions »
© 2010 - 2016. All Rights Reserved. Design by