I have a table called CustomerAnalysis which has one record with ID 1, My stored proc does not go into the if since the record exist. What am I doing wrong CusomerAnalysis: | ID| |:--| | 1 |
CREATE PROC proc_Insert ( @CustomerID INT = 1 ) AS BEGIN IF EXISTS(SELECT ID FROM Client WHERE Client.ID = @CustomerID) BEGIN UPDATE Client SET Client.ID = 2 WHERE Client.ID = @CustomerID END ELSE BEGIN INSERT INTO Client(ID) VALUES(@CustomerID) END END
ID
ID = 1
CustomerID
1
2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)