Tag Archives: ms sql

All Available Backups in MS SQL

10 Jun

In SQL Server 2008, to see all available db backups: select * from msdb.dbo.backupset

Get All rows into One String

13 May

This is an easy way to get all rows from a SQL table into a string: select stuff(( select ‘, ‘ + a_column from [name_of_table] order by table_id for xml path(”) ), 1, 1, ”)