呵呵.不可以。 SQL这么写:begin tran declare @ne varchar(20) select top 1 @ne=name from tperson order by personkey commit
exec('select top 1 name into '+ @ne + ' from tperson order by personkey')
begin tran declare @ne varchar(20) select top 1 @ne=name from tperson order by personkey commit select @ne --查看结果
exec('select top 1 name into '+ @ne + 'from tperson order by personkey')
那为什么我用这个得到@ne的值是空的呢 begin tran declare @ne varchar(20) declare @sql varchar(200) set @sql='select top 1 name into '+ @ne + ' from tperson order by personkey' exec(@sql) commit select @ne
楼主的意思是select一个列值到一个变量里?那就应该是declare @ne varchar(20) select top 1 @ne=name from tperson order by personkey print @ne前面几位用exec动态sql是把结果生成在@ne的一个table里,需要先对@ne进行赋值
begin tran declare @ne table(name varchar(50)) insert into @ne select top 1 name from tperson order by personkey commit
SQL这么写:begin tran
declare @ne varchar(20)
select top 1 @ne=name from tperson order by personkey
commit
declare @ne varchar(20)
select top 1 @ne=name from tperson order by personkey
commit
select @ne --查看结果
begin tran
declare @ne varchar(20)
declare @sql varchar(200)
set @sql='select top 1 name into '+ @ne + ' from tperson order by personkey'
exec(@sql)
commit
select @ne
select top 1 @ne=name from tperson order by personkey
print @ne前面几位用exec动态sql是把结果生成在@ne的一个table里,需要先对@ne进行赋值
declare @ne table(name varchar(50))
insert into @ne select top 1 name from tperson order by personkey
commit
thanks!
搂住早就这么说了,估计不会揭帖!呵呵!
declare @ne varchar(20)
select top 1 @ne=name from tperson order by personkey
commit
我这样用了,谢谢了。