Question

我正在撰写一份带有参数的MS Access Query,并想知道是否有可能将一个参数作为已归还的部分记录:

PARAMETERS [@SubmissionID] IEEEDouble, [@StartDate] DATETIME, [@EndDate] DATETIME;
INSERT INTO tblHUD_client_profile
(SubmissionID, ClientID)
SELECT [@SubmissionID] as SubmissionID, DISTINCT(ClientID) 
FROM tblClientEducation
WHERE (BeginDate BETWEEN [@StartDate] AND [@EndDate]
   OR EndDate BETWEEN [@StartDate] AND [@EndDate])
   AND NOT EXISTS(
                  Select ClientID 
                  from tblHUD_client_profile 
                  WHERE SubmissionID = [@SubmissionID] 
                  AND ClientID = tblClientEducation.ClientID
                  );

“Select [@SubmissionID] as SubmissionID”总能给我一个yn子错误。

我抱歉,如果已经从那里找到这一解决办法的话。我对这一点进行了研究,但是,在涉及“MS Access Queries”和“参数”的诸多基本问题上,我无法找到我所期待的东西。

Answer 1

After reviewing the original code, it seems to work as expected.

Answer 2

离开@MS Access:

PARAMETERS SubmissionID Integer;
SELECT [SubmissionID] as SubmissionID, DISTINCT(ClientID) 
FROM tblClientEducation

友情链接