Skip to content

Instantly share code, notes, and snippets.

@dannylloyd

dannylloyd/Audit.sql

Created May 21, 2013 17:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dannylloyd/5621702 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dannylloyd/5621702 to your computer and use it in GitHub Desktop.
Download ZIP
Auditing for SQL server
Raw
Audit.sql
UPDATE [dbo].person
SET FirstName = 'carl'
,LastName = 'smith'
,Updated = GETDATE()
OUTPUT 'UPDATE'
,DELETED.*
,INSERTED.*
INTO dbo.Person_History
WHERE person.id = 1
SELECT * FROM person_history ORDER BY id
DELETE
FROM person
OUTPUT 'DELETE'
,DELETED.*
,DELETED.*
INTO dbo.Person_History
WHERE person.id = 1
SELECT * FROM person_history ORDER BY id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment