kiddcj的专栏

在存储过程中declare @tablename varchar(50),@sql nvarchar(max),@orderid intset @tablename='orders'set @orderid=2set @sql='select * from'+ quotename(@tablename)+'where orderid='         +CAST(@orderid as varchar(10))+'order by orderid desc'exec(@sql)当@sql的长度超过4000