Title
|
Description
|
Applicability
|
SQL Server Migration Toolkit
|
There is host of useful TSQL for scripting core SQL Server objects in the Migration Toolkit section
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
Pivoting Rows into Columns
|
Pivot column values from multiple rows into a single delimited cell.
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
Auto-Create Call SP TSQL Templates
|
Auto-create TSQL templates for invoking all SPs in a database
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
Auto-Create Insert Into Table TSQL Templates
|
Auto-create TSQL templates for inserting into all tables in a database
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
Auto-Create Update each Table TSQL Templates
|
Auto-create TSQL templates for updating all tables in a database
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
Auto-Create Select from Table TSQL Templates
|
Auto-create TSQL templates for selecting from all tables in a database
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
Auto-Create Select from TVF TSQL Templates
|
Auto-create TSQL templates for selecting from all table-valued functions in a database
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
Expand all TABs in a String to Spaces
|
Replace all TABs in a string with spaces
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
Generate a descriptive list of SQL Agent jobs
|
Retrieve a compact list of SQL Agent jobs with a decoded (ie readable) schedule string
|
2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017
|
|
|
|
|