Using Stored Procedure to access three tables

Question

How to write a stored procedure to access three tables with parameter? Help

Pankaj Kumar Choudhary · Answer

Hye @deepak you can use this method Create Proc My_proc(@IId int @name nvarchar(50)@City nvarchar(50)) As Begin Select * from Table1 where IId=@iid; Select * from Table2 where Iid=@IId and name=@name select * from Table3 where IID=@IID End

Sivaraman Dhamodaran · Answer

You can use the below specified link to know about stored procedure which access database tables with parameters passed-in. Link