Use of switch and while loop in sql server 2005

Question

How to use Switch case in Sql server 2005 pls give me some example of swich and while loop in sql server 2005

Jignesh Trivedi · Answer

Hi In SQL server there is no swich case. but you may use case - when with select statement. example. Declare @ListPrice as int. // set value of @ListPrice SELECT CASE WHEN ListPrice = 0 THEN 'Mfg item - not for resale' WHEN ListPrice WHEN ListPrice >= 50 and ListPrice WHEN ListPrice >= 250 and ListPrice ELSE 'Over $1000' END hope this help.

Vulpes · Answer

Check out these links: http://msdn.microsoft.com/en-us/library/ms181765(SQL.90).aspx http://msdn.microsoft.com/en-us/library/ms178642(SQL.90).aspx Notice that it's just called a CASE expression not SWITCH CASE.