[Script Of Jun. 05] Find the SQL Server databases that contain a certain table or stored procedure

Jun. 05 Script Download:   The script is available for download from https://gallery.technet.microsoft.com//Find-the-SQL-Server-5e53757b.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This T-SQL script will demonstrate how to find the SQL Server databases that contain a certain table or stored procedure. Some people…

6

[Script Of Apr. 16] How to list the column names into one row for each table in a SQL Server databas

Apr. 16 Script Download:   The script is available for download from https://gallery.technet.microsoft.com//How-to-list-the-column-432bc5b4.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This script is to list the column names in one row for each table in a SQL Server database. Sometimes, people want…

5

[Script Of Jan. 17] How to sum the child nodes for a parent node in a SQL Server table

Jan. 17 Script Download:   The script is available for download from https://gallery.technet.microsoft.com//How-to-sum-the-child-nodes-9430fb12.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This script is to sum the child nodes for a parent node in a SQL Server table. As some people asked how…

5