34,593
社区成员
发帖
与我相关
我的任务
分享
DECLARE @id NUMERIC(10, 0)
SELECT @id = id FROM t1 WHERE pn = '123456'
IF @id > 0 --如果记录存在
UPDATE t1 SET status = 'Y' WHERE id=@id
ELSE
INSERT INTO t1(status, name) VALUES ('Y','张三')
END
DECLARE @id NUMERIC(10, 0)
SELECT @id = id FROM t1 WHERE pn = '123456'
IF @id > 0 --如果记录存在
begin
SELECT @id = id FROM t1 WHERE pn = '123456'
SELECT @id = id FROM t1 WHERE pn = '123456'
UPDATE t1 SET status = 'Y' WHERE id=@id
end
ELSE
begin
INSERT INTO t1(status, name) VALUES ('Y','张三')
SELECT @id = id FROM t1 WHERE pn = '123456'
SELECT @id = id FROM t1 WHERE pn = '123456'
SELECT @id = id FROM t1 WHERE pn = '123456'
end --有多条语句就要用begin ...end了
DECLARE @id NUMERIC(10, 0)
SELECT @id = id FROM t1 WHERE pn = '123456'
IF @id > 0 --如果记录存在
UPDATE t1 SET status = 'Y' WHERE id=@id
ELSE
INSERT INTO t1(status, name) VALUES ('Y','张三')
--END 这个END不需要 可以删除了