Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple Row Insert + Dynamic SQL
Hi All, I am trying to insert multiple rows using a single insert statement in a stored procedure. The code i am using is like - set s1 = 'Insert into table_name(x,y) values (?,?),(?,?)'; prepare s2 from s1; execute s2 using var1,var2,var3,var4; I am getting an error. Any advise appreciated...
