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 2005 Forums
 Transact-SQL (2005)
 Why print @qry is not working?

Author  Topic 

lovehui
Yak Posting Veteran

60 Posts

Posted - 2009-03-19 : 14:43:30
Hello,

I have a query @qry='select ....'
exec(@qry) is executed and no error on MSSMS
I want to display it so I print @qry to look at the result.
But why nothing?

What could be cause it?

Thanks

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-03-19 : 14:51:43
show us the code...

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-03-19 : 15:16:09
I remember you asking the exact same thing.
Go to Top of Page

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-03-19 : 15:16:44
Here you go. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121807&whichpage=2
And you have an answer there too.
Go to Top of Page
   

- Advertisement -