Technical Article

Copy rows generator

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: […]

You rated this post out of 5. Change rating

2004-02-13

248 reads

Technical Article

XSD Generator

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 […]

1 (1)

You rated this post out of 5. Change rating

2004-01-08

267 reads

Blogs

Friday Flyway Tips–Comparison Options

By

Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights

By

giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

Read the latest Blogs

Forums

SQL Window Functions Series: LAG() and LEAD()

By Nikhil Bangad

Comments posted to this topic are about the item SQL Window Functions Series: LAG()...

Breaking Biometrics

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Breaking Biometrics

Attaching Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Attaching Databases

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers