求解事件探查器中的语句 百分之百结帖
SET FMTONLY ON select time1 from tb WHERE 1=2 SET FMTONLY OFF
declare @P1 int
set @P1=2
exec sp_prepare @P1 output, N'@P1 bigint', N'SELECT time1 FROM tb WHERE (time1 > @P1)
', 1
select @P1
exec sp_unprepare 2
declare @P1 int
set @P1=3
exec sp_prepexec @P1 output, N'@P1 bigint', N'SELECT time1 FROM tb WHERE (time1 > @P1)
', 6430636800000
select @P1
SET NO_BROWSETABLE OFF
SET FMTONLY ON select time1,time1,time1 from tb2 WHERE 1=2 SET FMTONLY OFF
SET NO_BROWSETABLE ON
declare @P1 int
set @P1=4
exec sp_prepare @P1 output, N'@P1 bigint', N'SELECT * FROM tb2 WHERE (time1 < @P1)', 1
select @P1
exec sp_unprepare 4
declare @P1 int
set @P1=5
exec sp_prepexec @P1 output, N'@P1 bigint', N'SELECT * FROM tb2 WHERE (time1 < @P1)', 6430636800000
select @P1
请解释上面这些语句的意思 不要怕打字麻烦啊
6430636800000 这串数字是不是变量P1的值啊