Bu doğru, performans için. THEN'i silip denemek gerek.
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 )
Denedim. Maalesef Hata Alıyorum.
Static analysis:
1 errors were found during analysis.
- Unrecognized statement type. (near "IF EXISTS" at position 0)