In sql server 2008, i have a store procedure which has insert statement , now i want to insert multiple records at a time into table via EXEC.
MY Store Procedure:
insert into tblUser(fullname, email, loginID, password, DOB, question, answers,doc,roleid)
values (@fullname,@email,@loginID,HASHBYTES('sha512',@password),@dob,@question, @answers, GETDATE(),@roleid )
Now how to insert multiple records via EXEC
exec dbo.appReg_sp 'Hunain','smile','fdsaf','password','1999-12-1','asas','sasa',1 ; now what next ?