In SQL Server, the @@MAX_PRECISION configuration function returns the precision level used by decimal and numeric data types as currently set in the server.
No argument is required. You can simply use it in a SELECT statement to return the precision level of the current server.
In SQL Server, you can use the CRYPT_GEN_RANDOM() function to return a cryptographic, randomly-generated number. The number is generated by the Cryptographic Application Programming Interface (CAPI).
CAPI is a Microsoft Windows platform specific application programming interface included with Microsoft Windows operating systems that provides services to enable developers to secure Windows-based applications using cryptography.
The CRYPT_GEN_RANDOM() function accepts two arguments: the length (required), and a seed (optional).
The return value is varbinary(8000).
This article presents two ways to return a list of user-defined functions in a SQL Server database.
In SQL Server, you can use the SQL_VARIANT_PROPERTY() function to return base data type information from a sql_variant value.
The function accepts two arguments: the sql_variant value, and the property for which information is to be provided.
In SQL Server environments, two of the many string functions at our disposal are LEFT() and SUBSTRING().
These functions do a similar thing, but there are differences. This article looks at some of the main differences between these functions.
You may be familiar with the SET TEXTSIZE statement in SQL Server, that enables you to limit the amount of data returned in a SELECT query.
Perhaps you’re finding that its results are exactly the same as LEFT() when running a specific query. Which begs the question: Is there a difference between these two options?
In SQL Server, the @@TEXTSIZE configuration function returns the current value of the TEXTSIZE option.
No argument is required. You can simply use it in a SELECT statement to return the current TEXTSIZE value.
The TEXTSIZE value specifies the size of varchar(max), nvarchar(max), varbinary(max), text, ntext, and image data returned by a SELECT statement. This value can be set using SET TEXTSIZE.
In SQL Server, you can use the T-SQL IDENT_INCR() function to return the increment value of an identity column. This is the increment value specified when creating the identity column.
In SQL Server, you can use the T-SQL IDENT_SEED() function to return the original seed of an identity column. This is the original seed value specified when creating the identity column.
In SQL Server, if you ever need to return the value created in an identity column, you have several options. Each of these options, although similar, do a slightly different thing.