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,645 reads

Blogs

A simple powershell script to look up server hardware and OS information

By

This is a simple powershell script to query and display hardware and OS information...

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Introduction to SQL Server Execution Plans

By

Watch this week’s episode on YouTube! I nearly always use execution plans as the...

Read the latest Blogs

Forums

How to send queued emails

By dubem1-878067

After an upgrade,   sql server stopped sending emails.   Problem is not solved but during...

TLS 1.2 and Database mail

By miapjp

Hi, We use office 365, and just recently received an email from them saying...

Left join not pulling all from left table

By jeffshelix

T has 57,000 distinct rows Z has over a million.  I did row over...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers