DROP PROCEDURE引发语法错误

DROP PROCEDURE引发语法错误

你不能那样做。您需要使用动态sql。就像是 ：

DECLARE @object NVARCHAr(200)DECLARE @sql NVARCHAr(max)SET @object = (SELECt Top 1 Te.[this Object...] From #Temp Te)IF OBJECT_ID(@object) IS NOT NULLBEGIN    SET @sql = 'DROP PROCEDURE ' + @object    sp_executesql @sqlEND