Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to write switch case scenario in sp

Author  Topic 

imranabdulaziz
Yak Posting Veteran

83 Posts

Posted - 2007-07-06 : 02:15:08
Dear All,

I am using Sql server 2005



I would like to know Is it possible to use switch case(like we do in C#) in stored procedure.if not what if alternative of that. Because based on input parameter I would like to perform different action

Please guide me or give me some useful link.
Thanks


sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2007-07-06 : 02:30:31
Hi,

Yes its very much possible.

Please check the below link.

http://www.devx.com/tips/Tip/15633
http://www.craigsmullins.com/ssu_0899.htm

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu
Go to Top of Page
   

- Advertisement -