Debug Sql Cursor in SQL Server

Posted by Nismeh under Sql Server on 12/17/2013 | Points: 10 | Views : 1154 | Status : [Member] | Replies : 4
Hi,

I want to debug Sql Statements which I wrote to create a cursor. But if I am dubugging it I am getting an error. Can any one help me to aknowledge that how can i debug sql statements.?

IT KNOWLEDGE IS APPLIED KNOWLEDGE
So Just Do It



Responses

Posted by: vishalneeraj-24503 on: 12/17/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Please refer:-

http://msdn.microsoft.com/en-us/library/ms241871%28v=vs.90%29.aspx
http://technet.microsoft.com/en-us/library/ff953262%28v=sql.105%29.aspx
http://www.youtube.com/watch?v=rv_p0hEMpR8
http://blogs.msdn.com/b/billramo/archive/2009/04/11/transact-sql-debugger-for-sql-server-2008-part-1.aspx

Nismeh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 12/17/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer
http://exacthelp.blogspot.in/2012/03/how-to-debug-sql-queries-in-ssms-sql.html

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Nismeh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 12/17/2013 [Member] [MVP] Platinum | Points: 25
Posted by: Bandi on: 1/3/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
"Mark it as answer "

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Nismeh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response