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

Blogs

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Humble Bundle of Java Books

By

I try to keep an eye on the Humble Bundle bundles for books. The...

Read the latest Blogs

Forums

username upper case lower case how to fix

By sqlguy80

there is a field userid, firstname and last name which is allowing such userids...

File backup to dedicated nic

By tapiojaa

I've SQL Server 2019 Always On cluster (latest CU) that has 4 network adapters....

DBCC CheckDB errors

By mtz676

How can I identify automatically(like email alert if error shows up) through code if...

Visit the forum

Question of the Day

Updatable Views II

I have this view:

CREATE OR ALTER VIEW dbo.City 
AS
SELECT TOP 10 
 cn.CityNameID, cn.CityName
 FROM dbo.CityName AS cn
 WITH CHECK OPTION
GO
How can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')

See possible answers