Blog Archives

All Available Backups in MS SQL

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

Posted in Coding Tagged with:

Get All rows into One String

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, ”)

Posted in Coding Tagged with: