阅读背景:

带有INSERT语句的WHERE子句,WHERE处的“不正确的语法”,以及IF NOT NOT EXISTS运行,无论是否存在记录

来源:互联网 

I have this INSERT query:

我有这个INSERT查询:

INSERT INTO Appointments (StaffID, CustomerID, TimeSlot, AppDate) 
VALUES (1, 11, 1, DATEADD(day, 1, GETDATE()))
WHERE NOT EXISTS 
    (SELECT * FROM Appointments 
     WHERE StaffID = 1 AND CustomerID = 11 AND TimeSlot = 1 AND AppDate = DATEADD(day, 1, GETDATE()));
INS



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: