Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chinlax
Starting Member
30 Posts |
 Posted - 2011-10-14 : 02:51:37
|
| Hi All,here is the following questionwrite a procedure for inserting Multirecords on that above table Conditions:1.Here you can pass input parameters eid,ename,sal, did2.Execution Query wil be likeExec spMultiinsert '100,''kiran'',1000,1 ±101,''ravi'',2000,2±'Hint:first divide the statements into two records then insert into table.How to insert multirecords.Thanks in advance |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-14 : 04:01:44
|
| how do you identify start and end of each group of values. i think you should be passing it as XML or use different delimiters to indicate row end------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
stord-procedure for multinsert records