Technical Article

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

You rated this post out of 5. Change rating

2005-06-01 (first published: )

334 reads

Blogs

Parsing EXE Output in PowerShell

By

I saw a post internally that asked this question: Anyone have a handy powershell...

Connect With More Clients: Our Partner Directory Has Arrived

By

The partner directory connects your agency with new customers.

Can You See Who Forced a Plan

By

I had an excellent group of people in Gothenburg Sweden when I taught there...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

Output to flat file with no delimiter

By stricknyn

Hello all, Is there an easy way to output my records to a flat...

Refactoring Databases: Evolutionary Database Design

By Site Owners

Comments posted to this topic are about the item Refactoring Databases: Evolutionary Database Design

Visit the forum

Question of the Day

Concat Addition

What is the result of this code?

SELECT CONCAT(1, 2, 3) + 4

See possible answers