How to debug the stored procedure line by line?

Question

How to debug the stored procedure line by line like we debug the c# code in visual studio?

Vasanth Natarajan · Answer

hi Just Try this. 1.proc_name 'parameter''Parameter2' 2.Run The SQL Profiler and then Check your Procedure and Passing Parameter values

Vinay Singh · Answer

hi check the link https://msdn.microsoft.com/en-us/library/hh272701(v=vs.103).aspx https://msdn.microsoft.com/en-us/library/yet1b7by(v=vs.90).aspx

Jinish Gandhi · Answer

when you debugging in c# .net .first get stored procedure name and parameter value after that open sql server step-1. sp_helptext proc_name -> it show Prcodeure step-2. after click ctrl+t (for text format) after that again select sp_helptext proc_name and exucte with f5 step-3 now you have got the stored procedure after that put the parametere value in declration variable than execute sql query line by line.you will got the result try it:)