Tag: ms sql

itemprop="url"

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

Tagged with:

itemprop="url"

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

Tagged with:
Top