存储过程————等同于switch的功能语句

declare @tableName nvarchar(50)
set @tableName=case
     when @IDType='CustomerID' then 'Customer'
     when @IDType='EventRegistrationID' then 'EventRegistration'
     when @IDType='CustomerServiceID' then 'CustomerService'
     when @IDType='ReservationID' then 'Reservation'
     when @IDType='PartnerID' then 'Partner'
     when @IDType='LocationID' then 'Location'
     else 'LocationService'
end

 

关键字为红色的格式不能写错，case 不能单独写出来，必须将case语句赋给一个变量或放进select语句里