DELETE FROM [dbo].[SalesStaff] WHERE (([ID] = @Original_ID) AND ([Last_Name] = @Original_Last_Name) AND ([First_Name] = @Original_First_Name) AND ([Full_Time] = @Original_Full_Time) AND ([Hire_Date] = @Original_Hire_Date) AND ([Salary] = @Original_Salary)) INSERT INTO [dbo].[SalesStaff] ([ID], [Last_Name], [First_Name], [Full_Time], [Hire_Date], [Salary]) VALUES (@ID, @Last_Name, @First_Name, @Full_Time, @Hire_Date, @Salary); SELECT ID, Last_Name, First_Name, Full_Time, Hire_Date, Salary FROM SalesStaff WHERE (ID = @ID) SELECT ID, Last_Name, First_Name, Full_Time, Hire_Date, Salary FROM dbo.SalesStaff UPDATE [dbo].[SalesStaff] SET [ID] = @ID, [Last_Name] = @Last_Name, [First_Name] = @First_Name, [Full_Time] = @Full_Time, [Hire_Date] = @Hire_Date, [Salary] = @Salary WHERE (([ID] = @Original_ID) AND ([Last_Name] = @Original_Last_Name) AND ([First_Name] = @Original_First_Name) AND ([Full_Time] = @Original_Full_Time) AND ([Hire_Date] = @Original_Hire_Date) AND ([Salary] = @Original_Salary)); SELECT ID, Last_Name, First_Name, Full_Time, Hire_Date, Salary FROM SalesStaff WHERE (ID = @ID)