Breakpoints in SQL Management Studio

what is the use of breakpoints in SQL stored Procedures?? it doesnt serve same use as in visual studio.. it doesnt break execution?? then what is the use of adding it?? ELECT COUNT(P).ID) FROM #TempGetTable AS P WHERE P.Status IN ('v','c')

AND COALESCE(P.ID,'') <> ''
AND NOT EXISTS (SELECT 1 FROM CERT TGR WHERE TGR.ProcessID = P.ID AND TGR.Type='Take')
AND P.ProcessName = 'Take'

I added a breakpoint in above code.. it runs same as even when there is no breakpoints. Then why do we need to give that??

Answers


Assuming you're running from management studio: to use breakpoints, you have to run it in debug mode instead of executing, that should stop on breakpoints. (the green arrow or via the Debug menu)


Need Your Help

Is the Kernel Virtual Memory struct first formed when the process is about to execute?

c linux linux-kernel

I have been bothering with similar questions indirectly on my other posts. Now, my understanding is better. Thus, my questions are better. So, I want to summarize the facts here. This example is ba...