各式Case語法

C# JavaScript相同

switch (caseSwitch)
{
case 1:
Console.WriteLine("Case 1");
break;
case 2:
Console.WriteLine("Case 2");
break;
default:
Console.WriteLine("Default case");
break;
}


ASP VB

select case sRet
case "1"
case "2"
case else
end select


SQL

SELECT CASE ColumnA
WHEN '1' THEN '1Case'
WHEN '2' THEN '2Case'
ELSE 'ElseCase'
END AS StateName
FROM TableA