Dynamic SQL - SQL Server Forums

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)

Dynamic SQL

Author

Topic

ofsouto
Starting Member

22 Posts

Posted - 2005-12-15 : 06:45:34

Hi, dear

How can I get a variable value using dynamic SQL?
How can I execute the instruction bellow using dynamic SQL?

declare @var

select @var = count(*) from table_A

Thank you very much

Obede

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-15 : 07:00:07

declare @var int
select @var = count(*) from table_A
select @var

Madhivanan

Failing to plan is Planning to fail

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-15 : 07:01:02

use sp_executesql

declare @var int
exec sp_executesql N'select @var = count(*) from table_A', N'@var int OUTPUT', @var OUTPUT
select @var

-----------------
[KH]
Learn something new everyday

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-12-15 : 07:05:17

What front end are you using ?

query analyzer or running from a desktop app, or a web page ?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources