I know there is a
DBCC INPUTBUFFER command in SQL Server, which
To me it seems that input buffer IS the SQL a session is running.
SQL Server also has
I'm kind of confused. They seems very similar and unidentifiable to me.
I also come across an article
Understanding the sql_text Action in Extended Events by Jonathan Kehayias. In the article, he states
With this event session created, we can then run a couple of different test scenarios in the environment to show how this action is not the sql_text, but is instead the input_buffer for the event that is being fired
He's very confident that SQL text is not input buffer, which I don't understand the reason. Could anyone help clarify a little bit please? Thanks.