Generate Insert Statements

If you wish to save the contents of your database as insert statements, this script will generate a text file that has all data formatted as insert statements. This way you can save off the data as a script to send to a client or combine with a create script to rebuild the database on […]

2005-07-29 (first published: )

838 reads

Generate Quick Snapshot of table structures.

I use this script to quickly compare databases. In the past, I would generate creation scripts and compare those but that is tedious at best. This script generates a report of the metadata in an easy to read format that includes...- Table and Field Listing with types.- Foreign Key information- Primary Key and Index information- […]

5 (1)

2005-07-28 (first published: )

575 reads

Blogs

Daily Coping 5 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Stories to Engage Us

By Grant Fritchey

Comments posted to this topic are about the item Stories to Engage Us

Loading large JSON file into a Data Table to Bulk Copy into SQL Server Table

By sadie

We have a JSON file with 10M records to bulk copy load into a...

Help with OPENJSON for Google Maps API data

By tacy.highland

Hello, I'm a newbie when it comes to JSON so when I started down...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers