I've been assigned to deconstruct and document a rather large Stored Procedure (SQL 2008). This procedure simply declared about a dozen of other procedures with I will need to anaylize and document. I'm coming into an environment where a handleful of other developers wrote, programmed, and left and not a damn thing was documented. So, I along with the help of someone else, are decontructing it all and documenting it.
Anyway, the SP starts off like this:
ALTER PROCEDURE [dbo].[The Name of this very SP]
Exec [SP #1] 1
Exec [SP #2] 1
...and so on.
I have two questions.
1) What does @Dummy do?
2) What do the "1" indicate after firing off each SP?
Thanks in advance for your help!!