DELETE FROM [Branches] WHERE (([Title] = @Original_Title) AND ([Chief] = @Original_Chief) AND ([BranchID] = @Original_BranchID)) INSERT INTO [Branches] ([Title], [Chief]) VALUES (@Title, @Chief); SELECT Title, Chief, BranchID FROM Branches WHERE (BranchID = SCOPE_IDENTITY()) SELECT Title, Chief, BranchID FROM Branches UPDATE [Branches] SET [Title] = @Title, [Chief] = @Chief WHERE (([Title] = @Original_Title) AND ([Chief] = @Original_Chief) AND ([BranchID] = @Original_BranchID)); SELECT Title, Chief, BranchID FROM Branches WHERE (BranchID = @BranchID)