This stored procedure is created from the need to copy rows from a table with new value. The script itself will create stored procedure proc_copyrows.The parameters are@TableName: the table name@FilterField: filter field, default is null, means no filter@SourceValue: the value of filter field from source data to be copied@DestinationValue: the new value of filter field@SourceDB: […]
2004-02-13
254 reads
This script will generate a stored procedure named procCreateXSD. Run this script to create the SP.The purpose of this SP is to generate the XSD from selected tables we passed to the script. It accepts the Dataset name, URI, and the list of the tables to be included.For example:exec proccreateXSD 'NorthwindDataset', 'http://www.tempuri.org/', 'Customers,Orders,Products'Be aware that […]
2004-01-08
341 reads
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
By DataOnWheels
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...
Hello SSC, I am not sure if I posted this in the right spot,...
What is a partial backup for a read-write database?
See possible answers