Here’s another quiz. The procedure below is executed, “something” is run and the output changes on the next execution:
exec why_does_the_output_change; from this -- What happens here? exec why_does_the_output_change; to this
To cover off the easy options – no change is made to the code of the procedure and there’s no SQL within it (so the “mystery code” isn’t updating/inserting/deleting table data for example).
What did I do? Put your answers in the comments!
(Just as I finished writing this I thought of a second way this could be done, though arguably it involves a code change – can you get them both? Are there more options?)