Menu

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

    Understand SQL Server NEWID(), store GUIDs with uniqueidentifier, and compare NEWID() with NEWSEQUENTIALID().

  5. NEWSEQUENTIALID

    Learn how SQL Server NEWSEQUENTIALID() generates uniqueidentifier defaults, how it differs from NEWID(), and its privacy limits.

  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.