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语句里