bryant@mindfair.com

  • Interests: business intelligence, databases, computer programming, scouting, pro hockey

Technical Article

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

(8)

You rated this post out of 5. Change rating

2006-01-11 (first published: )

4,943 reads

Blogs

SQL Server 2025 Generally Available

By

This was announced last week at Microsoft Ignite and it's been covered by others...

Chatting with Power BI: Who Benefits from This Conversation?

By

"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...

A Quick Look at Redgate Data Modeler

By

Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...

Read the latest Blogs

Forums

SQL Server 2022 order by bug?

By hugo-939487

Hi, I was using order by on a column with characters and saw something...

SQL Server 2025 Build List

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2025 Build List

Filtered Indexes: The Developer’s Secret Weapon in SQL Server

By Chandan Shukla

Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...

Visit the forum

Question of the Day

Getting The Database Name

I run this code to connect to SQL Server 2022 from the command line.

sqlcmd -S localhost -E
At the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME()
GO
What is returned?

See possible answers