get exec() output into a variable

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

get exec() output into a variable

Author

Topic

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2007-03-17 : 03:06:21

Hi
I want to store exec() output into a variable how it will be.

declare @Tablename varchar(30)
select @Tablename ='USR012'
declare @SQLQuery1 varchar(100),@sqlquery2 integer
select @SQLQuery1='select count(*) from'+' '+@Tablename
select @sqlquery2=exec(@SQLQuery1)

Ranjeet Kumar Singh

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-17 : 03:12:20

use sp_executesql instead of exec()


declare @Tablename varchar(30)
select  @Tablename ='USR012'
declare @SQLQuery1 nvarchar(100), @sqlquery2 integer, @c int
select @SQLQuery1='select @c=count(*) from'+' '+@Tablename
select @sqlquery2=exec(@SQLQuery1)
exec sp_executesql @SQLQuery1, N'@c int output', @c output
select @c

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2007-03-17 : 03:25:27

A lot of Thanks

Ranjeet Kumar Singh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources