I am debugging my T-SQL code in Visual Studio ... is it possible for me to write something in my Transact-SQL code and have it pushed in either the Output Window or Immediate Window of Visual Studio... if yes how do I do it?
If I were writing a VB code for example it is simple .. I can just write debug.print "text write" ... and boom the text I want to end up in the Immediate Window gets there ... so how about in T-SQL being debugged in VS, how is it done?
I have spent hours in books and google without getting any closer to the answer I am seeking and I am hoping people out there who have more experience would shed light and give me some enlightenment on this.
This technique if possible would help me a lot in my debugging work. Thanks so much for all the help.
It's my first time to post a thread here and I can already see ... this place rocks!
I think I have discovered a way to do it: By simply doing something like (Select 'My text here') at critical points of my code (including inside event handler catch) then it ends up automatically where I want to see it so that I can examine the program flow..
Thanks again for all the help I really appreciate it.