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

2004-02-13

247 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)

2004-01-08

223 reads

Blogs

Amazon RDS Custom for SQL Server – A new beginning

By

Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was...

Getting Started with the Advent of Code as a #SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Your next step in the cloud

By

Over the last nine months I’ve presented (virtually) eleven times on a variety of...

Read the latest Blogs

Forums

Row limit for Updates before transaction log fills up

By Lord Slaagh

Hello SSC, I hope everyone is staying safe and healthy. I am using SQL...

Changing the Excel Rendering format???

By jbalbo

JHi I was wondering if anyone knew how I can change the Excel rendering...

concat + isnull

By abdalah.mehdoini

hello How to get output below query ple any one Suggest me. i will...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers