Home

Home: Overview of core functions

Getting started

		SQL code
Task	.NET code	CLR	Native (default naming convention)
Insert Row	AuditedInsert	dbo.CLR_SqlRetroview_AfterInsert
Update Row	AuditedUpdate	dbo.CLR_SqlRetroview_BeforeUpdate
Delete Row	AuditedDelete	dbo.CLR_SqlRetroview_AuditedDelete
Select Historical Data	SelectHistorical	dbo.CLR_SqlRetroview_SelectHistorical	SELECT * FROM TableName_Historical(date) (most convenient) EXEC sp_TableName_Historical date (most efficient)
Select Current Data	SelectCurrent		SELECT * FROM TableName_Current
Select Current and Deleted Data	SelectCurrentAndDeleted		SELECT * FROM TableName
Rollback Data	RollbackRows UndeleteRows
Associate UserID with Connection	SetCurrentUserID		dbo.SetCurrentUserID dbo.CurrentUserID()