SQL Server NEWID()
SQL Server NEWID() function is a system function that is used to generate a unique value of type uniqueidentifier.
Home »
sql server system function
SQL SERVER @@IDENTITY
SQL Server @@IDENTITY function is a system function that is used to get the last IDENTITY value generated for any table with an identity column under the current session, regardless of the scope of the T-SQL statement that generated the value.
SQL Server ISNUMERIC Function
SQL Server ISNUMERIC( ) function is System Functions which is used to check if the expression is valid numeric type or not.