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解决...