А через процедурку можно ? CREATE PROCEDURE dbo.DeleteEmployee ( @EmployeeID

Question

А через процедурку можно ? CREATE PROCEDURE dbo.DeleteEmployee ( @EmployeeID

int,
@ChangedBy nvarchar(50)
)
AS

-- TODO: Wrap this in a transaction; see http://www.4guysfromrolla.com/webtech/080305-1.shtml

-- First, update the ChangedBy field on Employees if needed
UPDATE Employees SET
ChangedBy = @ChangedBy
WHERE EmployeeID = @EmployeeID AND ChangedBy <> @ChangedBy

-- Finally, delete the record
DELETE FROM Employees
WHERE EmployeeID = @EmployeeID