Use of switch and while loop in sql server 2005

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 < 50 THEN 'Under $50'
         WHEN ListPrice >= 50 and ListPrice < 250 THEN 'Under $250'
         WHEN ListPrice >= 250 and ListPrice < 1000 THEN 'Under $1000'
         ELSE 'Over $1000'
      END

hope this help.

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.