Create TRIGGER TRIGGERDELETE ON Employee AFTER DELETE AS BEGIN Declare @id as int Declare @Name as nvarchar(10) select @id=EmployeeId,@Name=FirstName from deleted Insert Into EmployeeAUDIT1(Description) Values ('A Employee With Name '+ @Name + 'Id ' +CAST( @id as nvarchar)+ ' is deleted on '+ CAST(GETDATE() as nvarchar(10))) END GO
ALTER TABLE EmployeeEdit1 ALTER COlUMN DESCRIPTION NVARCHAR(1024)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)