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
247 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
237 reads
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
By Steve Jones
Today’s coping tip is to focus your attention on the good things you take...
By DataOnWheels
I had an amazing time adventuring to Wales with other members of the data...
Hi All, This is Naveen Maroju. My previous DBA was created distribution database later...
Hi All, I have the column of data in SQL Server. Here I need...
Comments posted to this topic are about the item Converting To/From User Friendly Trigesimal...
Ask SSC