Cool Tips‎ > ‎

Scripting SQL Server

 

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

 

 


Comments