view variable values inside queries

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 2008 Forums

Transact-SQL (2008)

view variable values inside queries

Author

Topic

Shachar
Starting Member

1 Post

Posted - 2010-11-03 : 04:31:21

Hi
want to build a query to monitor active users , and I was wondering if there is an option to view variables values within commands

for example if I run

select t1.name from t1 where id=@curr_id
how do I get to see the value of @curr_id

Thanks

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-11-03 : 04:51:31

If I am not wrong @Curr_id is the variable for which value you are going to pass.
What exactly you want ?

If you want to show value passed to variable you can just put the variable in select list.

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources