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
Sql-server – meaning of ## in SQL Server Profiler trace data
profilersql server
Related Question
- Sql-server – SQL Profiler Shows Update (EventClass) with No Errors, But Data in Table is Not Changed
- Sql-server – SQL profiler running on prod
- Sql-server – Why does SQL Server Profiler trace not capture SELECT operator in execution plans
- Sql-server – Is this considered a “light load” trace to run on SQL Server Profiler
- Sql-server – Do I need to keep SQL Server Profiler interface open
- Sql-server – How to keep a SQL Server Profiler trace from jumping to the bottom entry
- Sql-server – Unable to trace “Arithmetic overflow error converting numeric to data type numeric” error in profiler
Best Answer
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.