解决存储过程中表名为变量的问题

 IF EXISTS (
  SELECT *
    FROM INFORMATION_SCHEMA.ROUTINES
   WHERE SPECIFIC_SCHEMA = N'dbo'
     AND SPECIFIC_NAME = N'DelSameLotNumData'
)
   DROP PROCEDURE DelSameLotNumData
GO

 

Create Procedure DelSameLotNumData
@TableName nchar(10),@LotNum nchar(20)
as
exec ('delete '+@TableName+' where LotNum='''+@LotNum+'''')

 

--delete @TableName where LotNum=@LotNum   这是错误的

 

表名做变量时需用动态SQL解决...