--晕,怎么会,试试下面的
use DataBaseName
go
declare @Table nvarchar(50),
@Name nvarchar(50)
@sqlstr nvarchar(4000)
set @Tabel='Table_1'
set @sqlstr='select @Name1=Name from @Table1'
exec sp_executesql @sqlstr,N'@Name1 nvarchar(20) output,@Table1 nvarchar(50)',
@Name1=@Name output,@Table1 =@Table
use DataBaseName
go
declare @Table nvarchar(50),
@Name nvarchar(50)
@sqlstr nvarchar(4000)
set @Tabel='Table_1'
set @sqlstr='select @Name1=Name from @Table1'
exec sp_executesql @sqlstr,N'@Name1 nvarchar(20) output,@Table1 nvarchar(50)',
@Name1=@Name output,@Table1 =@Table
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货