what query is being executed by sql server engine

Question

hi,

there are many functions and variables i have used in my sql query. let us suppose that there are many replace functions, case statements, if statements . ... etc in a single query.

how i can i see, at last what query is being executed by the sql DB engine. i mean after executing all the case statemnts and functions in the query.

if some one found, please provide the links and info where can i find about this.

thanks.

Answer 1

You can use SQL Server Profiler (http://msdn.microsoft.com/en-us/library/ms187929.aspx) to determine what statement SQL Server is actually executing. However if you've got a single long statement with many functions you're likely to just see an exact copy of your input.

---

David Stewart | My Microsoft BI Blog | @dstewartbi