Technical Article

create an insert statement

Many times we are required to write lenghty insert statements for tables with many columns. This script will create an insert statement for u.It takes 2 parameters first tbale name and second the ordinal positions of the columns seperated by ','for example USP_GenerateInsert 'TabName' ,'1,2,3,4,5'Hope this is Helpful

3 (6)

You rated this post out of 5. Change rating

2007-10-01 (first published: )

1,737 reads

Blogs

A Very Cool Benefit in SSMS 21

By

I saw a post from Erin that Preview 2 is available. I’d gotten a...

AI Helping with an API

By

Can an AI help me with some database API work? Let’s see. This is...

Creating a “Real” Copy of a View: #SQLNewBlogger

By

I saw a post where a developer was trying to read the Information Schema...

Read the latest Blogs

Forums

Query is filling Tempdb

By Nita Reddy

I have query which is filling TEMPDB I need suggestion how to modify this...

Script is filling Tempdb

By Nita Reddy

I have query which is filling TEMPDB I need suggestion how to modify this...

Date data type not recognized with oledb type provider

By blom0344

Hello, We recently made the following observation working with  VS2022  combined with the SSIS...

Visit the forum

Question of the Day

The Hash Join III

In a hash join, if all the build input does not fit in memory, what type of hash join is this?

See possible answers