declare @a nvarchar(10)
declare @table nvarchar(20)
declare @s nvarchar(4000)
select @table='user_'+convert(nvarchar,getdate(),112)
set @s = N'select @a=col001 from '+@table
exec sp_executesql @s,N'@a nvarchar(10) out',@a out
select @a
declare @table nvarchar(20)
declare @s nvarchar(4000)
select @table='user_'+convert(nvarchar,getdate(),112)
set @s = N'select @a=col001 from '+@table
exec sp_executesql @s,N'@a nvarchar(10) out',@a out
select @a
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货