Alexander Chigrik

Generate Insert Statements Easily

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

3 (9)

2001-08-09

4,548 reads

Blogs

The Microsoft Power Platform

By

The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow....

From Evangelist to Advocate

By

It’s time for a little bit of change to occur. I am no longer...

Database File Changes

By

Data professionals around the globe are frequently finding themselves occupied with figuring out why...

Read the latest Blogs

Forums

Building a table based on another one(s)

By itmasterw 60042

Hi, We have 3 people that answer the phones to help our customer with...

Best way to find if string is whitespace

By BOR15K

I appreciate it is a trifling question and yet. One of our sites organises...

How to measure Latency between App and database server

By vsamantha35

Hi All, We have SQL Server instance running on a VM. Now we wanted...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers