A1VBCode Forums
Home
»
Classic Visual Basic (VB 6 or earlier)
»
Database Programming
How to insert multiple records through stored procedure?
http://www.a1vbcode.com/vbforums/Topic28075.aspx
By Makura
-
8/24/2009
How to insert all the records of one table to the another table through stored procedure in MS SQL by using loop.
If the records reach to end of file then exit.
By vb5prgrmr
-
8/25/2009
You don't need a loop. You can use an Insert into statement...
check out
http://www.tek-tips.com
and look for their sql server forum.
Good Luck