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)


4,548 reads


The Microsoft Power Platform


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

From Evangelist to Advocate


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

Database File Changes


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

Read the latest Blogs


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


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


SQL Server Q&A from the SQLServerCentral community

Get answers