asked on
SQL insert statement
I have a table 'test' with columns
Id, name, notes, definition, url, created_on updated_on
6232 samxx xxx xxx xxx xxx xxx
so now using cursor I want to insert 10,000 rows into 'test' table with same values. As"id" is the identity
column it will generate Id'd automatically.
Id, name, notes, definition, url, created_on updated_on
6232 samxx xxx xxx xxx xxx xxx
so now using cursor I want to insert 10,000 rows into 'test' table with same values. As"id" is the identity
column it will generate Id'd automatically.
Microsoft SQL Server 2008
Last Comment
Jim Horn
ASKER
Hey jimThanks for the reply and yes it was intended to do using cursor.. and also I have to insert this 10000 rows for an existing table lets say I have to insert it from 5000( it has already 5000 rows in it)
Is there some reason you want to do it in a loop? Why not do it with a single INSERT statement?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Why do you need a cursor when you can do it in one shot INSERT?
Curiosity overwhelms me ...
If you like what you see please click the big 'Was this article helpful?' button at the the bottom.
Good luck.
Jim