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

321 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Read the latest Blogs

Forums

Multiple rows of same site with different managers for each - how to pivot

By andrewjmdata

Hi, I have a table of sites where the there are multiple site names...

Inner Join creating duplicates in SQL along with Group By

By lynhudson1

I have two datasets, where I would like to join and then group by...

Trying to get output of PRINT command after select in Transaction

By boughrogers

Hi I am looking to select the output of the data that I plan...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers