Hi

How can I write one Stored procedure for Multipleoperations like ,
Insert,Update,Ritrive,Delete In a single stored procedure ,


regards
srinicasreddy

I don't think you can.


"srinivasreddy" <srinivask (AT) acuserv (DOT) net> wrote

"srinivasreddy" <srinivask (AT) acuserv (DOT) net> wrote

The only way I can think of is to use parameters to decide whether to
insert, update, select or delete.

CREATE StoredProcedure1
(@functype int,
....
)

IF @functype = 0
SELECT....
ELSE
IF @functype = 1
UPDATE...
ELSE
IF @functype = 2
DELETE...
ELSE
INSERT...

HTH