How to insert data into two diffrent tables using sp in sql

Seshu B

hi all,

i want to insert data into two diffrent tables based on Id using stored procedure in sql server

please provide soultion regarding this,

Thanks

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Persons

id(pk)

firstname

lastname

and

Orders

orderNumber

orderdetails

id(fk)

create procedure

@FirstName varchar(20),@OrderDetails varchar(20),@LastName varchar(20),@OrderNumber int

begin

declare @Temp int

insert into Hcl.dbo.a values(@FirstName,@LastName);

select @Temp=Id from Hcl.dbo.a where FirstName=@FirstName

insert into Hcl.dbo.b values(@Temp,@OrderDetails,@OrderNumber)

Hi,

According to my openion.

Create after insert trigger for first table and save the same data from "inserted" table to new table using stored procedure.

Hope this helps.

Thanks.

check : https://stackoverflow.com/questions/5545754/insert-with-the-same-data-in-different-tables

hi,

I think you want to insert single procedure then use it.

Create Procedure InsertData
(
@ID INT,
@Name NVARCHAR(100)=Null,
@Age NVARCHAR(100)=Null,
@Address NVARCHAR(100)=Null,
@FName NVARCHAR(100)=Null,
@MName NVARCHAR(100)=Null
)
AS
BEGIN
DECLARE @GETQID INT
IF EXISTS (SELECT *FROM PRIMARYTABLE WHERE ID=@ID )
BEGIN
---WRITE YOUR UPDATE QUERY
END
ELSE
BEGIN
INSERT INTO PRIMARYTABLENAME (NAME, AGE, ADDRESS) VALUES(@Name,@Age,@Address)
SET @GETQID =@@IDENTITY ----@@IDENTITY RETURN LAST INSERTED ID WHICH YOU REQUIRED FOR SAVE IN ANOTHER TABLE
END
---iNSERT DATA IN ANOTHER TABLE ON THE BEHALF OF @GETQID
INSERT INTO TABLEB (MASTERID,FATHERNAME,MOTHERNAME) VALUES (@GETQID,@FName,@MName)
END