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