Others

This page lists the functions in SQL Server that are not classified under other categories.

  1. @@IDENTITY

    In SQL Server, @@IDENTITY is a system variable used to return the identity column value of the most recently inserted row.

  2. @@ROWCOUNT

    In SQL Server, @@ROWCOUNT is a system variable used to return the number of rows affected by the last executed Transact-SQL statement.

  3. IDENT_CURRENT

    IDENT_CURRENT() is a function in SQL Server used to retrieve the last inserted identifier for a specific table.

  4. NEWID

    The NEWID() function is one of the functions in SQL Server used to generate globally unique identifiers (GUIDs).

  5. NEWSEQUENTIALID

    In SQL Server, the NEWSEQUENTIALID() function is used to generate a new, non-repeating GUID (globally unique identifier).

  6. SCOPE_IDENTITY

    In SQL Server, the SCOPE_IDENTITY() function is used to return the value of the most recently inserted identity column within the current scope.