store procedure

Question

can we use multiple sql command in a single store procedure

Vishal Prajapati · Answer

Ofcourse..you can use multiple sql commands in a single stord procedure...Please follow this link for an example.. 1) http://www.devasp.net/net/articles/display/1371.html

Nigel Fernandes · Answer

Yes you can use multiple commands.

Amit Kumar · Answer

Hi Dear Yes definitely you can use it. For example: CREATE PROCEDURE [dbo].[RoomDetails_Insertquery] ( @type int @roomno bigint @noofpersons bigint @roomtype nvarchar(150) @amt bigint ) AS BEGIN IF @type=1 BEGIN INSERT INTO roomdetails VALUES (@roomno@noofpersons@roomtype@amt) END ELSE IF @type=2 BEGIN SELECT * FROM roomdetails WHERE roomno=@roomno END ELSE IF @type=3 BEGIN UPDATE roomdetails SET noofpersons=@noofpersonsroomtype=@roomtype@amt=amt WHERE roomno=@roomno END END For more details You can follow the below links. http://kushonline.blogspot.in/2012/07/how-use-multiple-query-in-single-stored.html http://stackoverflow.com/questions/18628842/multiple-separate-sql-queries-in-one-stored-procedure Regards Amit

Bikesh Srivastava · Answer

Yes difinatly why not you can use...

Daniel Jones · Answer

yes