QUA_GET_INCREMENTAL_MARKER

Returns a marker value for a last updated row in a table. It may a timestamp, id or anything else. String type is used as a content base.

Syntax

QUA_GET_INCREMENTAL_MARKER ( 'object_name' )

Arguments

'object_name'

Is an expression of the type sysname.

Return types

nvarchar(1000)

Example

SELECT cast(QUA_GET_INCREMENTAL_MARKER ('dbo.UserCache') as datetime2) as LastUpdated;

See Also