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#