存储过程————执行拼接的SQL语句的字符串

 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

declare @sqlstr nvarchar(500)

set @sqlstr='select @Count=count(*) from '+@tableName+ ' where '+@IDType+'='+cast(@TestID as char);

exec sp_executesql @sqlstr,N'@Count int output',@Count output

 

如果有参数的话，在执行这个字符串时，将参数加在后面，例如：@Count