Satır Mevcutsa UPDATE Mevcut Değilse INSERT Sorgusu

  IF EXISTS (SELECT * FROM personeller WHERE mid = '300')
THEN
  UPDATE personeller
  SET sid = 1, lid = 1, tid = 50, pid = 415
  WHERE mid = 300
ELSE
  INSERT INTO personeller (sid, lid, tid, pid, mid)
  VALUES (1, 1, 50, 415, 300)

IF EXISTS (SELECT Id FROM dbo.GroupInfo WHERE Id = @ID)
UPDATE dbo.GroupInfo
SET App = @APP , DB = @DB WHERE Id = @ID
ELSE
INSERT INTO dbo.GroupInfo ( Id , App , DB )
VALUES ( @ID , @APP , @DB )

IF EXISTS (SELECT Id FROM dbo.GroupInfo WHERE Id = @ID)
UPDATE dbo.GroupInfo
SET App = @APP , DB = @DB WHERE Id = @ID
ELSE
INSERT INTO dbo.GroupInfo ( Id , App , DB )
VALUES ( @ID , @APP , @DB )

1. Unrecognized statement type. (near "IF EXISTS" at position 0)

  IF EXISTS (SELECT * FROM personeller WHERE mid = 300)
THEN
  UPDATE personeller
  SET sid = 1, lid = 1, tid = 50, pid = 415
  WHERE mid = 300
ELSE
  INSERT INTO personeller (sid, lid, tid, pid, mid)
  VALUES (1, 1, 50, 415, 300)