Script Table Data to Insert Statements

This script will create a series of insert statements for a given table. It does not support every single data type in every way and has some limitations. If you add any enhancements, please send them to me at bbyrd@intellithought.com so I can update it here. Update (28 Feb 2005): Added support/Fixed bug with smalldatetime […]

4.25 (8)

2006-01-11 (first published: )

4,670 reads

Blogs

Data Visualization, Context, and Domain Expertise

By

I recently posted a graph to twitter and asked people to explain it. Let’s...

Approaches to running Databricks ETL code from Azure ADF

By

Databricks is fantastic, but there is a small issue with how people use it....

Creating a New Sequence–#SQLNewBlogger

By

I wrote about sequences in an editorial recently and decided to start using them....

Read the latest Blogs

Forums

Invalid object name OPENJSON

By BOR15K

I have an Express edition of SQL 2019 Microsoft SQL Server 2019 (RTM-GDR) (KB4517790)...

SSMS Copy Database utiliy - how solid is it & can you rely on it?

By sqlguy7777

Hi   If I want to make a 100% accurate copy of a database...

T-SQL parsing query

By rocky_498

Hi Guys, I need help with the SQL query. I need help with parsing...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Minus Query

See possible answers