SELECT...CASE in stored procedures
Hi friends,
I m writing some stored procedures.
Pls tell me, how can we use IF..ELSE, nested IF..ELSE in stored procedure. means i want to pass a int parameter to stored procedure & according to this value, we will execute my queries.
eg if i=1 then insert, if i=2 then update or if i=3 then update. Also i can choose different SELECT statement according to i.
Now how can i use the SELECT....CASE in stored procedure. means same above thing i want to do with SELECT....CASE. For example, for case 1, i want to write insert statement, for case 2 update statement & for case 3 delete statement.
pls give details
|
