CREATE PROCEDURE SAVEORUPDATEID(@ID INT,....) AS BEGIN IF EXISTS(SELECT 1 FROM TB WHERE ID=@ID) UPDATE TB SET .... WHERE ID=@ID ELSE INSERT INTO TB(ID,....) SELECT @ID,..... END
create proc test @id as begin if exists(select 1 from tb where id=@id) update .. else insert.. end
if exists(select 1 from tb where id=@id) update .. else insert.. end
AS
BEGIN
IF EXISTS(SELECT 1 FROM TB WHERE ID=@ID)
UPDATE TB SET .... WHERE ID=@ID
ELSE
INSERT INTO TB(ID,....)
SELECT @ID,.....
END
@id
as
begin
if exists(select 1 from tb where id=@id)
update ..
else
insert..
end
if exists(select 1 from tb where id=@id)
update ..
else
insert..
end