Cinchy system values

Overview

The Cinchy system values covered in this section:

• @cinchy_row_id

@cinchy_row_id

The @cinchy_row_id function returns the cinchy ID of the last-inserted row.

Syntax

select @cinchy_row_id

Examples

INSERT INTO [Contacts].[People] ([First Name],[Last Name])
VALUES ('John','Smith')

select @cinchy_row_id