create proc SP_CheckTable
(
@TableName Nvarchar(100)
)Asselect * from @TableName
where (companyname is null or companyname = '')出错了,说@TableName有问题,请问是哪里出错呢?谢谢
(
@TableName Nvarchar(100)
)Asselect * from @TableName
where (companyname is null or companyname = '')出错了,说@TableName有问题,请问是哪里出错呢?谢谢
(
@TableName Nvarchar(100)
)Asdeclare @sql varchar(2000)
set @sql = '
select * from '+ @TableName + '
where (companyname is null or companyname = '''')'exec(@sql)
只能用动态SQL语句