store procedure

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

)

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=@noofpersons,roomtype=@roomtype,@amt=amt WHERE roomno=@roomno

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

5 Replies

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

Vishal Prajapati9y ago
Accepted 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
Amit Kumar9y ago
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=@noofpersons,roomtype=@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
Daniel Jones9y ago
yes
Bikesh Srivastava9y ago
Yes difinatly why not you can use...
Nigel Fernandes9y ago
Yes you can use multiple commands.