how to write stored procedure to insert values into two tables?

Question

hi how to write a single stored procedure to insert values into two tables at a time. columns are different in two tables. Please give a stored procedure, urgent please help me. Thanks.

Vasanth · Answer

Please check the code , CREATE PROCEDURE dbo.InsertTwoTables @address1 nvarchar(500), @mobileno nvarchar(50), AS BEGIN TRY BEGIN TRANSACTION -- Start the transaction Set Nocount On DECLARE @ID int INSERT INTO Table1(Address, MobileNo) VALUES (@address1, @mobileno) SELECT @ID=@@IDENTITY INSERT INTO ImageInAlbum(FKID, Address, MobileNo) VALUES (@ID, @address1, @mobileno) -- If we reach here, success! COMMIT END TRY BEGIN CATCH -- Error IF @@TRANCOUNT > 0 ROLLBACK -- Raise an error DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int SELECT @ErrMsg = ERROR_MESSAGE(), @ErrSeverity = ERROR_SEVERITY() RAISERROR(@ErrMsg, @ErrSeverity, 1) END CATCH Hope it helps out , please mark as answer.

Altaf Patel · Answer

CREATE PROCEDURE sp_myStoredProcedure @myInput int, @myString varchar(100), @myFloat AS begin Select column1, column2 From Table1 Where column1 = @myInput Select column1, column2 From Table2 Where column1 = @myString and column2 = myFloat end calling store procedure... >>>>>>> sp_myStoredProcedure ..,..,.. inside begin ---- end you can write queries and use parameters declare above.... mark answer if usefull.. Thanx Altaf......

how to write stored procedure to insert values into two tables?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)