Generate Insert Statements Easily - Updated

This script will generate insert statements for the given tables. You can pass the tables names, separated by commas, into sp_DataAsInsCommand stored procedure as in the example below:EXEC sp_DataAsInsCommand 'employee,titleauthor,pub_info'Updated on 5/25/01 to correct an issue with columns that are short like a column defined as char(1), to correct another issue with the Identity column […]

2005-06-01 (first published: )

318 reads

Blogs

Your First Jupyter Notebook

By

In April, I said I was going to start learning Jupyter Notebooks. It’s November....

Using Visual Studio Code

By

I’m a creature of habit. I have my routine when I get to my...

Docker Containers and Persistent Data

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

The Conference Springboard

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Conference Springboard

Missing Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Missing Data

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Missing Data

See possible answers