然后 Access 使用以下命令创建 SQL 准备好的语句sp_prepexec
一次从表/视图十 (10) 行中检索整行。第一个电话看起来像这样......
declare @p1 int
set @p1=4
exec sp_prepexec @p1 output,N'@P1 int,@P2 int,@P3 int,@P4 int,@P5 int,@P6 int,@P7 int,@P8 int,@P9 int,@P10 int',N'SELECT "ID","AgentName" FROM "dbo"."myTbl" WHERE "ID" = @P1 OR "ID" = @P2 OR "ID" = @P3 OR "ID" = @P4 OR "ID" = @P5 OR "ID" = @P6 OR "ID" = @P7 OR "ID" = @P8 OR "ID" = @P9 OR "ID" = @P10',358,359,360,361,362,363,364,365,366,367
select @p1
...并且每个后续调用都使用sp_execute
,像这样的
exec sp_execute 4,368,369,370,371,372,373,374,375,376,377