I want to create trigger which contain the history of updation
<pre lang="SQL">Alter TRIGGER bandlevel_Trg_Upd ON [dbo].[Employee]
FOR UPDATE
AS
INSERT [dbo].[Test] (emp_id,emp_code,emp_pan_card,emp_gender,GETDATE(),status)
SELECT emp_id,emp_code,emp_pan_card,emp_gender,,=Date 'BEFORE UPDATE'
FROM deleted
INSERT [dbo].[Test] (emp_id,emp_code,emp_pan_card,emp_gender,status,GETDATE())
SELECT emp_id,emp_code,emp_pan_card,emp_gender,Date, 'AFTER UPDATE'
FROM inserted</pre>
but in this trigger it create two table. iwant in single table and show the detail of table which change