SQLSERVER语法如下
IF NOT EXISTS
(
SELECT 1
FROM T1
WHERE Id = 4
)
BEGIN
xxxx
END
DM可改成
begin
IF not Exists(SELECT id FROM T1 where id=4) then
INSERT into T1(id,name) values (4,'王五');
end if;
end;
文章
阅读量
获赞