create procedure test
@name varchar(100) output
as
begin
select @name=name from [user] where id=1
end
go
@name varchar(100) output
as
begin
select @name=name from [user] where id=1
end
go
SELECT name FROM [user] where id=1
declare @name varchar(100)
OPEN crr_name
WHILE @@fetch_status=0
begin
fetch next from crr_name into @name
print @name
end
close crr_name
deallocate crr_name
create procedure test
as
begin
if object_id('tempdb..#tmp1') is not null
drop table #tmp1
select name into #tmp1 from [user] where id=1
end
goselect name from #tmp1
exec('select * from [user] where id=1')
declare @num,
@sqls
set @sqls='select count(*) from ' + @servername + '.a.dbo.b'
exec(@sqls)
我如何能将exec执行的结果存入变量@num中declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from '+@servername+'.a.dbo.b'
exec sp_executesql @sqls,N'@a int output',@num output
select @num
declare @sqls nvarchar(4000)
set @sqls='select @name=name from [user] where id=1'
exec sp_executesql @sqls,N'@name nvarchar(100) output',@name output
select @name