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

231 reads

Blogs

Storage Field Day 23 – HammerSpace

By

I am thrilled to have been a part of this year’s Storage Field Day...

Daily Coping 16 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Why You (usually) Want a Clustered Index

By

Note: I originally wrote this a few years ago but never posted it. It...

Read the latest Blogs

Forums

Migration of Data from one Database to Multiple Databases

By vamshi.sql

Hello, I have a requirement to migrate the data from existing AWS RDS DB...

AWS Beginner questions

By cariebens

I'm having some trouble wrapping my head around the relationship between EC2 instances and...

How to get weekly and Monthly view from daily in sql server

By Krish319

Hello All, I have a table like below. I need to get daily,weekly and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers