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

233 reads

Blogs

New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters

By

My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Read the latest Blogs

Forums

Case statement with time

By pedroccamara

Hello everyone I hope everyone's ok. I have this query and I'm trying to...

what are the best books to become a SQL developer?

By vpmaciel

what are the best books to become a SQL developer?

what are the best books to become a DBA SQL?

By vpmaciel

what are the best books to become a DBA SQL?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers