Doing some maintenance on an old report created by someone long ago. I notice data source for the report is a stored procedure. The sproc call looks like this:
EXEC someStoredProc;1
I've never seen the ";1" before. Just curious what the heck it is? Can't find any documentation online. If I switch the "1" to any other number, SQL throws error "cannot find stored procedure 'someStoredProc'". But switch it back to "1" and it works. Doesn't seem to have any impact on output. What is this thing?
I noticed I can put ";1" after any stored procedure and it executes seemingly the same as without it.
If anyone can clear up this mystery for me - thank you!