I'm running a trace using the SQL Server Profiler. The trace data contains the following lines:

WHERE CAST(LEFT(pc.Time_stamp,11) AS DATETIME >= ##
AND CAST(LEFT(pc.Time_stamp, 11) AS DATETIME) <= ##

What does the ## mean

  • What version of SQL Server?
    – BateTech
    Jan 13, 2015 at 11:18

1 Answer 1


First, if you're using SQL Server 2008 or higher, the Profiler is deprecated - look into using Extended Events instead.

The ## marks serve as a placeholder for the value of the variables being used in the query.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.