adoquery的sql是TspProc '2007','10','get',使用adoprocstore的效果也是一样
下面sql log,想知道为什么在执行后又prepare了次?高手们谁来介绍下阿exec sp_unprepare 4
go
declare @P1 int
set @P1=-1
exec sp_prepare @P1 output, NULL, N'exec TspProc ''2007'',''10'',''get''
', 1
select @P1
go
SET FMTONLY ON exec sp_execute 5 SET FMTONLY OFF
go
exec sp_unprepare 5
go
declare @P1 int
set @P1=-1
exec sp_prepexec @P1 output, NULL, N'exec TspProc ''2007'',''10'',''get''
'
select @P1
go
exec sp_unprepare 6
go
下面sql log,想知道为什么在执行后又prepare了次?高手们谁来介绍下阿exec sp_unprepare 4
go
declare @P1 int
set @P1=-1
exec sp_prepare @P1 output, NULL, N'exec TspProc ''2007'',''10'',''get''
', 1
select @P1
go
SET FMTONLY ON exec sp_execute 5 SET FMTONLY OFF
go
exec sp_unprepare 5
go
declare @P1 int
set @P1=-1
exec sp_prepexec @P1 output, NULL, N'exec TspProc ''2007'',''10'',''get''
'
select @P1
go
exec sp_unprepare 6
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货