Hi Every one !
I need to insert a set of values which are passed thru the parameter ,Below is the code to do the Single table insertion , Now I need to do multiple table insertion ie, to insert values with the addtional parameter in another table but using the same stored procedure !!
CREATE procedure [dbo].[Pro_SIDN]
@SID int,
@FirstName varchar(10),
@MiddleName varchar(10),
@LastName varchar(10),
@FullName varchar(10),
insert into tableA(SID,Firs tname,Middlenam e,Lastname,Full name)
values (@SID,@FirstNam e,@MiddleName,@ LastName,@FullN ame)
Kindly provide me with some sample code ASAP !
Thanks in advance !
I need to insert a set of values which are passed thru the parameter ,Below is the code to do the Single table insertion , Now I need to do multiple table insertion ie, to insert values with the addtional parameter in another table but using the same stored procedure !!
CREATE procedure [dbo].[Pro_SIDN]
@SID int,
@FirstName varchar(10),
@MiddleName varchar(10),
@LastName varchar(10),
@FullName varchar(10),
insert into tableA(SID,Firs tname,Middlenam e,Lastname,Full name)
values (@SID,@FirstNam e,@MiddleName,@ LastName,@FullN ame)
Kindly provide me with some sample code ASAP !
Thanks in advance !
Comment