Windows NT DGPENSV2LPKMN 10.0 build 14393 (Windows Server 2016) AMD64
Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25
: 172.16.0.66 | : 172.16.0.254
Cant Read [ /etc/named.conf ]
7.3.25
SYSTEM
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
[ A ]
[ C ]
[ D ]
C: /
laragon /
bin /
heidisql /
[ HOME SHELL ]
Name
Size
Permission
Action
Backups
[ DIR ]
drwxrwxrwx
Snippets
[ DIR ]
drwxrwxrwx
plugins
[ DIR ]
drwxrwxrwx
LICENSE-openssl
6.1
KB
-rw-rw-rw-
fbclient-4.0.dll
1.92
MB
-rw-rw-rw-
functions-interbase.ini
1.86
KB
-rw-rw-rw-
functions-mariadb.ini
398.11
KB
-rw-rw-rw-
functions-mssql.ini
59.31
KB
-rw-rw-rw-
functions-mysql.ini
58.49
KB
-rw-rw-rw-
functions-postgresql.ini
9.23
KB
-rw-rw-rw-
functions-redshift.ini
39.54
KB
-rw-rw-rw-
functions-sqlite.ini
68.68
KB
-rw-rw-rw-
gpl.txt
17.9
KB
-rw-rw-rw-
heidisql.exe
21.06
MB
-rwxrwxrwx
ibclient64-14.1.dll
1.97
MB
-rw-rw-rw-
libcrypto-1_1-x64.dll
3.1
MB
-rw-rw-rw-
libiconv-2.dll
1.61
MB
-rw-rw-rw-
libintl-8.dll
669.67
KB
-rw-rw-rw-
libmariadb.dll
1007.25
KB
-rw-rw-rw-
libmysql-6.1.dll
4.65
MB
-rw-rw-rw-
libmysql.dll
4.53
MB
-rw-rw-rw-
libpq-10.dll
277.5
KB
-rw-rw-rw-
libpq-12.dll
287
KB
-rw-rw-rw-
libssl-1_1-x64.dll
904.21
KB
-rw-rw-rw-
plink.exe
715.73
KB
-rwxrwxrwx
portable.lock
0
B
-rw-rw-rw-
portable_settings.txt
5.28
KB
-rw-rw-rw-
sqlite3.dll
2.06
MB
-rw-rw-rw-
tabs.ini
174
B
-rw-rw-rw-
Delete
Unzip
Zip
${this.title}
Close
Code Editor : functions-mssql.ini
[$PARTITION] declaration=database_name,partition_function_name,expression category=System description=Returns the partition number into which a set of partitioning column values would be mapped for any specified partition function in SQL Server 2017. [@@CONNECTIONS] declaration= category=System Statistical description=This function returns the number of attempted connections - both successful and unsuccessful - since SQL Server was last started [@@CONNECTIONS] declaration= category=System Statistical description=This function returns the number of attempted connections - both successful and unsuccessful - since SQL Server was last started. [@@CPU_BUSY] declaration= category=System Statistical description=This function returns the amount of time that SQL Server has spent in active operation since its latest start. @@CPU_BUSY returns a result measured in CPU time increments, or "ticks." This value is cumulative for all CPUs, so it may exceed the actual elapsed time. To convert to microseconds, multiply by @@TIMETICKS. [@@CURSOR_ROWS] declaration= category=Cursor description=This returns the number of qualifying rows currently in the last cursor opened on the connection. To improve performance, SQL Server can populate large keyset and static cursors asynchronously. @@CURSOR_ROWS can be called to determine that the number of the rows that qualify for a cursor are retrieved at the time of the @@CURSOR_ROWS call. [@@DATEFIRST] declaration= category=Date and time description=This function returns the current value of SET DATEFIRST, for a specific session. [@@DBTS] declaration= category=Configuration description=This function returns the value of the current timestamp data type for the current database. The current database will have a guaranteed unique timestamp value. [@@ERROR] declaration= category=System description=Returns the error number for the last Transact-SQL statement executed. [@@FETCH_STATUS] declaration= category=Cursor description=This function returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection. [@@IDENTITY] declaration= category=System description=Is a system function that returns the last-inserted identity value. [@@IDLE] declaration= category=System Statistical description=Returns the time that SQL Server has been idle since it was last started. The result is in CPU time increments, or "ticks," and is cumulative for all CPUs, so it may exceed the actual elapsed time. Multiply by @@TIMETICKS to convert to microseconds. [@@IO_BUSY] declaration= category=System Statistical description=Returns the time that SQL Server has spent performing input and output operations since SQL Server was last started. The result is in CPU time increments ("ticks"), and is cumulative for all CPUs, so it may exceed the actual elapsed time. Multiply by @@TIMETICKS to convert to microseconds. [@@LANGID] declaration= category=Configuration description=Returns the local language identifier (ID) of the language that is currently being used. [@@LANGUAGE] declaration= category=Configuration description=Returns the name of the language currently being used. [@@LOCK_TIMEOUT] declaration= category=Configuration description=Returns the current lock time-out setting in milliseconds for the current session. [@@MAX_CONNECTIONS] declaration= category=Configuration description=Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. The number returned is not necessarily the number currently configured. [@@MAX_PRECISION] declaration= category=Configuration description=Returns the precision level used by decimal and numeric data types as currently set in the server. [@@NESTLEVEL] declaration= category=Configuration description=Returns the nesting level of the current stored procedure execution (initially 0) on the local server. [@@OPTIONS] declaration= category=Configuration description=Returns information about the current SET options. [@@PACKET_ERRORS] declaration= category=System Statistical description=Returns the number of network packet errors that have occurred on SQL Server connections since SQL Server was last started. [@@PACK_RECEIVED] declaration= category=System description=Returns the number of input packets read from the network by SQL Server since it was last started. [@@PACK_SENT] declaration= category=System Statistical description=Returns the number of output packets written to the network by SQL Server since it was last started. [@@PROCID] declaration= category=Metadata description=Returns the object identifier (ID) of the current Transact-SQL module. A Transact-SQL module can be a stored procedure, user-defined function, or trigger. @@PROCID cannot be specified in CLR modules or the in-process data access provider. [@@REMSERVER] declaration= category=Configuration description=Important This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use linked servers and linked server stored procedures instead. [@@ROWCOUNT] declaration= category=System description=Returns the number of rows affected by the last statement. If the number of rows is more than 2 billion, use ROWCOUNT_BIG. [@@SERVERNAME] declaration= category=Configuration description=Returns the name of the local server that is running SQL Server. [@@SERVICENAME] declaration= category=Configuration description=Returns the name of the registry key under which SQL Server is running. @@SERVICENAME returns 'MSSQLSERVER' if the current instance is the default instance; this function returns the instance name if the current instance is a named instance. [@@SPID] declaration= category=Configuration description=Returns the session ID of the current user process. [@@TEXTSIZE] declaration= category=Configuration description=Returns the current value of the TEXTSIZE option. [@@TIMETICKS] declaration= category=System Statistical description=Returns the number of microseconds per tick. [@@TOTAL_ERRORS] declaration= category=System Statistical description=Returns the number of disk write errors encountered by SQL Server since SQL Server last started. [@@TOTAL_READ] declaration= category=System Statistical description=Returns the number of disk reads, not cache reads, by SQL Server since SQL Server was last started. [@@TOTAL_WRITE] declaration= category=System Statistical description=Returns the number of disk writes by SQL Server since SQL Server was last started. [@@VERSION] declaration= category=Configuration description=Returns system and build information for the current installation of SQL Server. [ABS] declaration=numeric_expression category=Mathematical description=A mathematical function that returns the absolute (positive) value of the specified numeric expression. (ABS changes negative values to positive values. ABS has no effect on zero or positive values.) [ACOS] declaration=float_expression category=Mathematical description=A function that returns the angle, in radians, whose cosine is the specified float expression. This is also called arccosine. [APPLOCK_MODE] declaration='database_principal','resource_name','lock_owner' category=Metadata description=This function returns the lock mode held by the lock owner on a particular application resource. As an application lock function, APPLOCK_MODE operates on the current database. The database is the scope of the application locks. [APPLOCK_TEST] declaration=' database_principal ',' resource_name ',' lock_mode ',' lock_owner ' category=Metadata description=This function returns information as to whether or not a lock can be granted on a particular application resource, for a specified lock owner, without acquisition of the lock. As an application lock function, APPLOCK_TEST operates on the current database. The database is the scope of the application locks. [APPROX_COUNT_DISTINCT] declaration=expression category=Aggregate description=This function returns the approximate number of unique non-null values in a group. [APP_NAME] declaration= category=Metadata description=This function returns the application name for the current session, if the application sets that name value. [ASCII] declaration=character_expression category=String description=Returns the ASCII code value of the leftmost character of a character expression [ASIN] declaration=float_expression category=Mathematical description=A function that returns the angle, in radians, whose sine is the specified float expression. This is also called arcsine. [ASSEMBLYPROPERTY] declaration=assembly_name,property_name category=Metadata description=This function returns information about a property of an assembly. [ASYMKEYPROPERTY] declaration=Key_ID,'algorithm_desc','string_sid','sid' category=Cryptographic description=This function returns the properties of an asymmetric key. [ASYMKEY_ID] declaration=Asym_Key_Name category=Cryptographic description=Returns the ID of an asymmetric key. [ATAN] declaration=float_expression category=Mathematical description=A function that returns the angle, in radians, whose tangent is a specified float expression. This is also called arctangent. [ATN2] declaration=float_expression category=Mathematical description=Returns the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x), where x and y are the values of the two specified float expressions. [AVG] declaration=all,distinct,expression category=Aggregate description=This function returns the average of the values in a group. It ignores null values [BINARY_CHECKSUM] declaration=*** category=System description=Returns the binary checksum value computed over a row of a table or over a list of expressions. [CAST AND CONVERT] declaration=expression,data_type,length,style category=Conversion description=These functions convert an expression of one data type to another. [CEILING] declaration=numeric_expression category=Mathematical description=This function returns the smallest integer greater than, or equal to, the specified numeric expression. [CERTENCODED] declaration=cert_id category=Security description=This function returns the public portion of a certificate in binary format. This function takes a certificate ID as an argument, and returns the encoded certificate. To create a new certificate, pass the binary result to CREATE CERTIFICATE … WITH BINARY. [CERTPRIVATEKEY] declaration=certificate_ID,encryption_password,decryption_password category=Security description=This function returns the private key of a certificate in binary format. This function takes three arguments. [CERTPROPERTY] declaration=Cert_ID,Expiry_Date,Start_Date,Issuer_Name,Cert_Serial_Number,Subject,SID,String_SID category=Cryptographic description=Returns the value of a specified certificate property. [CERT_ID] declaration= category=Cryptographic description=This function returns the ID value of a certificate. [CHARINDEX] declaration=expressionToFind,expressionToSearch,start_location category=String description=This function searches for one character expression inside a second character expression, returning the starting position of the first expression if found. [CHAR] declaration=integer_expression category=String description=This function converts an int ASCII code to a character value. [CHECKSUM] declaration=* category=System description=The CHECKSUM function returns the checksum value computed over a table row, or over an expression list. Use CHECKSUM to build hash indexes. [CHECKSUM_AGG] declaration=ALL,DISTINCT,expression category=Aggregate description=This function returns the checksum of the values in a group. CHECKSUM_AGG ignores null values. The OVER clause can follow CHECKSUM_AGG. [CHOOSE] declaration=index,val_1 … val_n category=Logical description=Returns the item at the specified index from a list of values in SQL Server. [COLLATIONPROPERTY] declaration=collation_name,property category=Collation description=This function returns the property of a specified collation in SQL Server 2017. [COLUMNPROPERTY] declaration=id,column,property category=Metadata description=This function returns column or parameter information. [COLUMNS_UPDATED] declaration= category=Trigger description=This function returns a varbinary bit pattern indicating the inserted or updated columns of a table or view. Use COLUMNS_UPDATED anywhere inside the body of a Transact-SQL INSERT or UPDATE trigger to test whether the trigger should execute certain actions. [COL_LENGTH] declaration=' table ',' column ' category=Metadata description=This function returns the defined length of a column, in bytes. [COL_NAME] declaration=table_id,column_id category=Metadata description=This function returns the name of a table column, based on the table identification number and column identification number values of that table column. [COMPRESS] declaration=expression category=System description=This function compresses the input expression, using the GZIP algorithm. The function returns a byte array of type varbinary(max). [CONCAT] declaration=string_value category=String description=This function returns a string resulting from the concatenation, or joining, of two or more string values in an end-to-end manner. (To add a separating value during concatenation, see CONCAT_WS.) [CONCAT_WS] declaration=separator,argument1, argument2, argumentN category=String description=This function returns a string resulting from the concatenation, or joining, of two or more string values in an end-to-end manner. It separates those concatenated string values with the delimiter specified in the first function argument. (CONCAT_WS indicates concatenate with separator.) [CONNECTIONPROPERTY] declaration=property category=System description=For a request that comes in to the server, this function returns information about the connection properties of the unique connection which supports that request. [CONTEXT_INFO] declaration= category=System description=This function returns the context_info value either set for the current session or batch, or derived through use of the SET CONTEXT_INFO statement. [COS] declaration=float_expression category=Mathematical description=A mathematical function that returns the trigonometric cosine of the specified angle - measured in radians - in the specified expression. [COT] declaration=float_expression category=Mathematical description=A mathematical function that returns the trigonometric cotangent of the specified angle - in radians - in the specified float expression. [COUNT] declaration=all,distinct,expression,* category=Aggregate description=This function returns the number of items found in a group [COUNT_BIG] declaration=ALL,DISTINCT,expression,***,OVER ( [ partition_by_clause ] [ order_by_clause ] ) category=Aggregate description=This function returns the number of items found in a group. COUNT_BIG operates like the COUNT function. These functions differ only in the data types of their return values. COUNT_BIG always returns a bigint data type value. COUNT always returns an int data type value. [CRYPT_GEN_RANDOM] declaration=length,seed category=Cryptographic description=This function returns a cryptographic, randomly-generated number, generated by the Crypto API (CAPI). CRYPT_GEN_RANDOM returns a hexadecimal number with a length of a specified number of bytes. [CUME_DIST] declaration= category=Analytic description=For SQL Server, this function calculates the cumulative distribution of a value within a group of values. In other words, CUME_DIST calculates the relative position of a specified value in a group of values. Assuming ascending ordering, the CUME_DIST of a value in row r is defined as the number of rows with values less than or equal to that value in row r, divided by the number of rows evaluated in the partition or query result set. CUME_DIST is similar to the PERCENT_RANK function. [CURRENT_REQUEST_ID] declaration= category=System description=This function returns the ID of the current request within the current session. [CURRENT_TIMESTAMP] declaration= category=Date and time description=This function returns the current database system timestamp as a datetime value, without the database time zone offset. CURRENT_TIMESTAMP derives this value from the operating system of the computer on which the instance of SQL Server runs. [CURRENT_TRANSACTION_ID] declaration= category=System description=This function returns the transaction ID of the current transaction in the current session. [CURRENT_USER] declaration= category=Security description=This function returns the name of the current user. This function is equivalent to USER_NAME(). [CURSOR_STATUS] declaration='local','cursor_name','global','variable','cursor_variable' category=Cursor description=For a given parameter, CURSOR_STATUS shows whether or not a cursor declaration has returned a cursor and result set. [DATABASEPROPERTYEX] declaration=database,property category=Metadata description=For a specified database in SQL Server, this function returns the current setting of the specified database option or property. [DATABASE_PRINCIPAL_ID] declaration=principal_name category=Metadata description=This function returns the ID number of a principal in the current database. See Principals (Database Engine) for more information about principals. [DATALENGTH] declaration=expression category=Data type description=This function returns the number of bytes used to represent any expression. [DATEADD] declaration=datepart category=Date and time description=This function adds a specified number value (as a signed integer) to a specified datepart of an input date value, and then returns that modified value. [DATEDIFF] declaration=datepart category=Date and time description=This function returns the count (as a signed integer value) of the specified datepart boundaries crossed between the specified startdate and enddate. [DATEDIFF_BIG] declaration=datepart category=Date and time description=This function returns the count (as a signed big integer value) of the specified datepart boundaries crossed between the specified startdate and enddate. [DATEFROMPARTS] declaration=year,month,day category=Date and time description=This function returns a date value that maps to the specified year, month, and day values. [DATENAME] declaration=datepart category=Date and time description=This function returns a character string representing the specified datepart of the specified date. [DATEPART] declaration=datepart category=Date and time description=This function returns an integer representing the specified datepart of the specified date. [DATETIME2FROMPARTS] declaration=year,month,day,hour,minute,seconds,fractions,precision category=Date and time description=This function returns a datetime2 value for the specified date and time arguments. The returned value has a precision specified by the precision argument. [DATETIMEFROMPARTS] declaration=year,month,day,hour,minute,seconds,milliseconds category=Date and time description=This function returns a datetime value for the specified date and time arguments. [DATETIMEOFFSETFROMPARTS] declaration=year,month,day,hour,minute,seconds,fractions,hour_offset,minute_offset,precision category=Date and time description=Returns a datetimeoffset value for the specified date and time arguments. The returned value has a precision specified by the precision argument, and an offset as specified by the offset arguments. [DAY] declaration=date category=Date and time description=This function returns an integer that represents the day (day of the month) of the specified date. [DB_ID] declaration='database_name' category=Metadata description=This function returns the database identification (ID) number of a specified database. [DB_NAME] declaration= category=Metadata description=This function returns the name of a specified database. [DECOMPRESS] declaration=expression category=System description=This function will decompress an input expression value, using the GZIP algorithm. DECOMPRESS will return a byte array (VARBINARY(MAX) type). [DECRYPTBYASYMKEY] declaration=Asym_Key_ID,ciphertext,@ciphertext,Asym_Key_Password category=Cryptographic description=This function uses an asymmetric key to decrypt encrypted data. [DECRYPTBYCERT] declaration=certificate_ID,ciphertext,@ciphertext,cert_password,@cert_password category=Cryptographic description=This function uses the private key of a certificate to decrypt encrypted data. [DECRYPTBYKEYAUTOASYMKEY] declaration=akey_ID,akey_password,@ciphertext,add_authenticator,@add_authenticator,authenticator,@authenticator,@add_authenticator,authenticator,@authenticator category=Cryptographic description=This function decrypts encrypted data. To do this, it first decrypts a symmetric key with a separate asymmetric key, and then decrypts the encrypted data with the symmetric key extracted in the first "step". [DECRYPTBYKEYAUTOCERT] declaration=cert_ID,cert_password,'ciphertext',@ciphertext,add_authenticator,@add_authenticator,authenticator,@authenticator category=Cryptographic description=This function decrypts data with a symmetric key. That symmetric key automatically decrypts with a certificate. [DECRYPTBYKEY] declaration=ciphertext,@ciphertext,add_authenticator,authenticator,@authenticator category=Cryptographic description=This function uses a symmetric key to decrypt data. [DECRYPTBYPASSPHRASE] declaration=passphrase,@passphrase category=Cryptographic description=This function decrypts data originally encrypted with a passphrase. [DEGREES] declaration=numeric_expression category=Mathematical description=This function returns the corresponding angle, in degrees, for an angle specified in radians. [DENSE_RANK] declaration=<partition_by_clause>,<order_by_clause> category=Ranking description=This function returns the rank of each row within a result set partition, with no gaps in the ranking values. The rank of a specific row is one plus the number of distinct rank values that come before that specific row. [DIFFERENCE] declaration=character_expression category=String description=This function returns an integer value measuring the difference between the SOUNDEX() values of two different character expressions. [ENCRYPTBYASYMKEY] declaration=asym_key_ID,cleartext category=Cryptographic description=This function encrypts data with an asymmetric key. [ENCRYPTBYCERT] declaration=certificate_ID,cleartext,@cleartext category=Cryptographic description=Encrypts data with the public key of a certificate. [ENCRYPTBYKEY] declaration=key_GUID,'cleartext',@cleartext,add_authenticator,@add_authenticator,authenticator,@authenticator category=Cryptographic description=Encrypts data by using a symmetric key. [ENCRYPTBYPASSPHRASE] declaration=passphrase,@passphrase,cleartext,@cleartext,add_authenticator,@add_authenticator,authenticator,@authenticator category=Cryptographic description=Encrypt data with a passphrase using the TRIPLE DES algorithm with a 128 key bit length. [EOMONTH] declaration=start_date,month_to_add category=Date and time description=This function returns the last day of the month containing a specified date, with an optional offset. [ERROR_LINE] declaration= category=System description=This function returns the line number of occurrence of an error that caused the CATCH block of a TRY…CATCH construct to execute. [ERROR_MESSAGE] declaration= category=System description=This function returns the message text of the error that caused the CATCH block of a TRY…CATCH construct to execute. [ERROR_NUMBER] declaration= category=System description=This function returns the error number of the error that caused the CATCH block of a TRY…CATCH construct to execute. [ERROR_PROCEDURE] declaration= category=System description=This function returns the name of the stored procedure or trigger where an error occurs, if that error caused the CATCH block of a TRY…CATCH construct to execute. [ERROR_SEVERITY] declaration= category=System description=This function returns the severity value of the error where an error occurs, if that error caused the CATCH block of a TRY…CATCH construct to execute. [ERROR_STATE] declaration= category=System description=Returns the state number of the error that caused the CATCH block of a TRY…CATCH construct to be run. [EVENTDATA] declaration= category=Trigger description=This function returns information about server or database events. When an event notification fires, and the specified service broker receives the results, EVENTDATA is called. A DDL or logon trigger also support internal use of EVENTDATA. [EXP] declaration=float_expression category=Mathematical description=Returns the exponential value of the specified float expression. [FILEGROUPPROPERTY] declaration=filegroup_name,property category=Metadata description=This function returns the filegroup property value for a specified name and filegroup value. [FILEGROUP_ID] declaration= category=Metadata description=This function returns the filegroup identification (ID) number for a specified filegroup name. [FILEGROUP_NAME] declaration= category=Metadata description=This function returns the filegroup name for the specified filegroup identification (ID) number. [FILEPROPERTY] declaration=file_name,property category=Metadata description=Returns the specified file name property value when a file name in the current database and a property name are specified. Returns NULL for files that are not in the current database. [FILE_IDEX] declaration=file_name category=Metadata description=This function returns the file identification (ID) number for the specified logical name of a data, log, or full-text file of the current database. [FILE_ID] declaration=file_name category=Metadata description=For the given logical name for a component file of the current database, this function returns the file identification (ID) number. [FILE_NAME] declaration=file_id category=Metadata description=This function returns the logical file name for a given file identification (ID) number. [FIRST_VALUE] declaration=scalar_expression,OVER ( [ partition_by_clause ] order_by_clause [ rows_range_clause ] ) category=Analytic description=Returns the first value in an ordered set of values in SQL Server 2017. [FLOOR] declaration=numeric_expression category=Mathematical description=Returns the largest integer less than or equal to the specified numeric expression. [FORMATMESSAGE] declaration=msg_number,msg_string,param_value category=System description=Constructs a message from an existing message in sys.messages or from a provided string. The functionality of FORMATMESSAGE resembles that of the RAISERROR statement. However, RAISERROR prints the message immediately, while FORMATMESSAGE returns the formatted message for further processing. [FORMAT] declaration=value,format,culture category=String description=Returns a value formatted with the specified format and optional culture in SQL Server 2017. Use the FORMAT function for locale-aware formatting of date/time and number values as strings. For general data type conversions, use CAST or CONVERT. [FULLTEXTCATALOGPROPERTY] declaration= category=Metadata description=Returns information about full-text catalog properties in SQL Server 2017. [FULLTEXTSERVICEPROPERTY] declaration=property category=Metadata description=Returns information related to the properties of the Full-Text Engine. These properties can be set and retrieved by using sp_fulltext_service. [GETANSINULL] declaration='database' category=System description=Returns the default nullability for the database for this session. [GETDATE] declaration= category=Date and time description=Returns the current database system timestamp as a datetime value without the database time zone offset. This value is derived from the operating system of the computer on which the instance of SQL Server is running. [GETUTCDATE] declaration= category=Date and time description=Returns the current database system timestamp as a datetime value. The database time zone offset is not included. This value represents the current UTC time (Coordinated Universal Time). This value is derived from the operating system of the computer on which the instance of SQL Server is running. [GET_FILESTREAM_TRANSACTION_CONTEXT] declaration= category=System description=Returns a token that represents the current transaction context of a session. The token is used by an application to bind FILESTREAM file-system streaming operations to the transaction. For a list of FILESTREAM topics, see Binary Large Object (Blob) Data (SQL Server). [GROUPING] declaration=<column_expression> category=Aggregate description=Indicates whether a specified column expression in a GROUP BY list is aggregated or not. GROUPING returns 1 for aggregated or 0 for not aggregated in the result set. GROUPING can be used only in the SELECT <select> list, HAVING, and ORDER BY clauses when GROUP BY is specified. [GROUPING_ID] declaration=<column_expression> category=Aggregate description=Is a function that computes the level of grouping. GROUPING_ID can be used only in the SELECT <select> list, HAVING, or ORDER BY clauses when GROUP BY is specified. [HASHBYTES] declaration='<algorithm>',@input,' input ' category=Cryptographic description=Returns the MD2, MD4, MD5, SHA, SHA1, or SHA2 hash of its input in SQL Server. [HAS_DBACCESS] declaration='database_name' category=Security description=Returns information about whether the user has access to the specified database. [HAS_PERMS_BY_NAME] declaration=securable,securable_class,permission,sub-securable category=Security description=Evaluates the effective permission of the current user on a securable. A related function is fn_my_permissions. [HOST_ID] declaration= category=System description=Returns the workstation identification number. The workstation identification number is the process ID (PID) of the application on the client computer that is connecting to SQL Server. [HOST_NAME] declaration= category=System description=Returns the workstation name. [IDENTITY (FUNCTION)] declaration=data_type,seed,increment,column_name category=Data type description=Is used only in a SELECT statement with an INTO table clause to insert an identity column into a new table. Although similar, the IDENTITY function is not the IDENTITY property that is used with CREATE TABLE and ALTER TABLE. [IDENT_CURRENT] declaration=table_name category=Data type description=Returns the last identity value generated for a specified table or view. The last identity value generated can be for any session and any scope. [IDENT_INCR] declaration=' table_or_view ' category=Data type description=Returns the increment value (returned as numeric (@@MAXPRECISION,0)) specified during the creation of an identity column in a table or view that has an identity column. [IDENT_SEED] declaration=' table_or_view ' category=Data type description=Returns the original seed value (returned as numeric(@@MAXPRECISION,0)) that was specified when an identity column in a table or a view was created. Changing the current value of an identity column by using DBCC CHECKIDENT does not change the value returned by this function. [IIF] declaration=boolean_expression,true_value,false_value category=Logical description=Returns one of two values, depending on whether the Boolean expression evaluates to true or false in SQL Server. [INDEXKEY_PROPERTY] declaration=object_ID,index_ID,key_ID,property category=Metadata description=Returns information about the index key. Returns NULL for XML indexes. [INDEXPROPERTY] declaration=object_ID,index_or_statistics_name,property category=Metadata description=Returns the named index or statistics property value of a specified table identification number, index or statistics name, and property name. Returns NULL for XML indexes. [INDEX_COL] declaration=database_name,schema_name,table_or_view_name,index_id,key_id category=Metadata description=Returns the indexed column name. Returns NULL for XML indexes. [ISDATE] declaration=expression category=Date and time description=Returns 1 if the expression is a valid date, time, or datetime value; otherwise, 0. [ISJSON] declaration=expression category=JSON description=Tests whether a string contains valid JSON. [ISNULL] declaration=check_expression,replacement_value category=System description=Replaces NULL with the specified replacement value. [ISNUMERIC] declaration=expression category=System description=Determines whether an expression is a valid numeric type. [IS_MEMBER] declaration=' group ',' role ' category=Security description=Indicates whether the current user is a member of the specified Microsoft Windows group or SQL Server database role. [IS_OBJECTSIGNED] declaration='OBJECT',@object_id,@class category=Cryptographic description=Indicates whether an object is signed by a specified certificate or asymmetric key. [IS_ROLEMEMBER] declaration=' role ',' database_principal ' category=Security description=Indicates whether a specified database principle is a member of the specified database role. [IS_SRVROLEMEMBER] declaration=' role ' category=Security description=Indicates whether a SQL Server login is a member of the specified server role. [JSON_MODIFY] declaration=expression,path category=JSON description=Updates the value of a property in a JSON string and returns the updated JSON string. [JSON_QUERY] declaration=expression,path category=JSON description=Extracts an object or an array from a JSON string. [JSON_VALUE] declaration=expression,path category=JSON description=Extracts a scalar value from a JSON string. [KEY_GUID] declaration=' Key_Name ' category=Cryptographic description=Returns the GUID of a symmetric key in the database. [KEY_ID] declaration=' Key_Name ' category=Cryptographic description=Returns the ID of a symmetric key in the current database. [KEY_NAME] declaration=ciphertext,key_guid category=Cryptographic description=Returns the name of the symmetric key from either a symmetric key GUID or cipher text. [LAG] declaration=scalar_expression,offset,default category=Analytic description=Accesses data from a previous row in the same result set without the use of a self-join starting with SQL Server 2012 (11.x). [LAST_VALUE] declaration=scalar_expression,OVER ( [ partition_by_clause ] order_by_clause [ rows_range_clause ] ) category=Analytic description=Returns the last value in an ordered set of values in SQL Server 2017. [LEAD] declaration=scalar_expression,offset,default,OVER ( [ partition_by_clause ] order_by_clause) category=Analytic description=Accesses data from a subsequent row in the same result set without the use of a self-join starting with SQL Server 2012 (11.x). LEAD provides access to a row at a given physical offset that follows the current row. Use this analytic function in a SELECT statement to compare values in the current row with values in a following row. [LEFT] declaration=character_expression,integer_expression category=String description=Returns the left part of a character string with the specified number of characters. [LEN] declaration=string_expression category=String description=Returns the number of characters of the specified string expression, excluding trailing blanks. [LOG10] declaration=float_expression category=Mathematical description=Returns the base-10 logarithm of the specified float expression. [LOGINPROPERTY] declaration=login_name,propertyname category=Security description=Returns information about login policy settings. [LOG] declaration=float_expression,base category=Mathematical description=Returns the natural logarithm of the specified float expression in SQL Server. [LOWER] declaration=character_expression category=String description=Returns a character expression after converting uppercase character data to lowercase. [LTRIM] declaration=character_expression category=String description=Returns a character expression after it removes leading blanks. [MAX] declaration=ALL,DISTINCT,expression,OVER ( [ partition_by_clause ] order_by_clause) category=Aggregate description=Returns the maximum value in the expression. [MIN] declaration=ALL,DISTINCT,expression,OVER ( [ partition_by_clause ] order_by_clause) category=Aggregate description=Returns the minimum value in the expression. May be followed by the OVER clause. [MIN_ACTIVE_ROWVERSION] declaration= category=System description=Returns the lowest active rowversion value in the current database. A rowversion value is active if it is used in a transaction that has not yet been committed. For more information, see rowversion (Transact-SQL). [MONTH] declaration=date category=Date and time description=Returns an integer that represents the month of the specified date. [NCHAR] declaration=integer_expression category=String description=Returns the Unicode character with the specified integer code, as defined by the Unicode standard. [NEWID] declaration= category=System description=Creates a unique value of type uniqueidentifier. [NEWSEQUENTIALID] declaration= category=System description=Creates a GUID that is greater than any GUID previously generated by this function on a specified computer since Windows was started. After restarting Windows, the GUID can start again from a lower range, but is still globally unique. When a GUID column is used as a row identifier, using NEWSEQUENTIALID can be faster than using the NEWID function. This is because the NEWID function causes random activity and uses fewer cached data pages. Using NEWSEQUENTIALID also helps to completely fill the data and index pages. [NEXT VALUE FOR] declaration=database_name,schema_name,sequence_name,over_order_by_clause category=Metadata description=Generates a sequence number from the specified sequence object. [NTILE] declaration=integer_expression,<partition_by_clause>,<order_by_clause> category=Ranking description=Distributes the rows in an ordered partition into a specified number of groups. The groups are numbered, starting at one. For each row, NTILE returns the number of the group to which the row belongs. [OBJECTPROPERTYEX] declaration=id,property category=Metadata description=Returns information about schema-scoped objects in the current database. For a list of these objects, see sys.objects (Transact-SQL). OBJECTPROPERTYEX cannot be used for objects that are not schema-scoped, such as data definition language (DDL) triggers and event notifications. [OBJECTPROPERTY] declaration=id,property category=Metadata description=Returns information about schema-scoped objects in the current database. For a list of schema-scoped objects, see sys.objects (Transact-SQL). This function cannot be used for objects that are not schema-scoped, such as data definition language (DDL) triggers and event notifications. [OBJECT_DEFINITION] declaration=object_id category=Metadata description=Returns the Transact-SQL source text of the definition of a specified object. [OBJECT_ID] declaration=' object_name ',' object_type ' category=Metadata description=Returns the database object identification number of a schema-scoped object. [OBJECT_NAME] declaration=object_id,database_id category=Metadata description=Returns the database object name for schema-scoped objects. For a list of schema-scoped objects, see sys.objects (Transact-SQL). [OBJECT_SCHEMA_NAME] declaration=object_id,database_id category=Metadata description=Returns the database schema name for schema-scoped objects. For a list of schema-scoped objects, see sys.objects (Transact-SQL). [OPENDATASOURCE] declaration=provider_name,init_string category=Rowset description=Provides ad hoc connection information as part of a four-part object name without using a linked server name. [OPENJSON] declaration= category=Rowset description=OPENJSON is a table-valued function that parses JSON text and returns objects and properties from the JSON input as rows and columns. In other words, OPENJSON provides a rowset view over a JSON document. You can explicitly specify the columns in the rowset and the JSON property paths used to populate the columns. Since OPENJSON returns a set of rows, you can use OPENJSON in the FROM clause of a Transact-SQL statement just as you can use any other table, view, or table-valued function. [OPENQUERY] declaration=linked_server,' query ' category=Rowset description=Executes the specified pass-through query on the specified linked server. This server is an OLE DB data source. OPENQUERY can be referenced in the FROM clause of a query as if it were a table name. OPENQUERY can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement. This is subject to the capabilities of the OLE DB provider. Although the query may return multiple result sets, OPENQUERY returns only the first one. [OPENROWSET] declaration='provider_name','datasource','user_id','password','provider_string',catalog,schema,object,'query',BULK category=Rowset description=Includes all connection information that is required to access remote data from an OLE DB data source. This method is an alternative to accessing tables in a linked server and is a one-time, ad hoc method of connecting and accessing remote data by using OLE DB. For more frequent references to OLE DB data sources, use linked servers instead. For more information, see Linked Servers (Database Engine). The OPENROWSET function can be referenced in the FROM clause of a query as if it were a table name. The OPENROWSET function can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement, subject to the capabilities of the OLE DB provider. Although the query might return multiple result sets, OPENROWSET returns only the first one. [OPENXML] declaration=idoc,rowpattern,flags category=Rowset description=OPENXML provides a rowset view over an XML document [ORIGINAL_DB_NAME] declaration= category=Metadata description=Returns the database name that is specified by the user in the database connection string. This is the database that is specified by using the sqlcmd-d option (USE database) or the ODBC data source expression (initial catalog =databasename). [ORIGINAL_LOGIN] declaration= category=Security description=Returns the name of the login that connected to the instance of SQL Server. You can use this function to return the identity of the original login in sessions in which there are many explicit or implicit context switches. [PARSENAME] declaration='object_name',object_piece category=Metadata description=Returns the specified part of an object name. The parts of an object that can be retrieved are the object name, owner name, database name, and server name. [PARSE] declaration=string_value,data_type,culture category=Conversion description=Returns the result of an expression, translated to the requested data type in SQL Server. [PATINDEX] declaration=pattern,expression category=String description=Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types. [PERCENTILE_CONT] declaration=numeric_literal,WITHIN GROUP ( ORDER BY order_by_expression [ ASC | DESC ]),OVER ( <partition_by_clause> ) category=Analytic description=Calculates a percentile based on a continuous distribution of the column value in SQL Server. The result is interpolated and might not be equal to any of the specific values in the column. [PERCENTILE_DISC] declaration=literal,WITHIN GROUP ( ORDER BY order_by_expression [ ASC | DESC ]),OVER ( <partition_by_clause> ) category=Analytic description=Computes a specific percentile for sorted values in an entire rowset or within distinct partitions of a rowset in SQL Server. For a given percentile value P, PERCENTILE_DISC sorts the values of the expression in the ORDER BY clause and returns the value with the smallest CUME_DIST value (with respect to the same sort specification) that is greater than or equal to P. For example, PERCENTILE_DISC (0.5) will compute the 50th percentile (that is, the median) of an expression. PERCENTILE_DISC calculates the percentile based on a discrete distribution of the column values; the result is equal to a specific value in the column. [PERCENT_RANK] declaration=OVER ( [ partition_by_clause ] order_by_clause) category=Analytic description=Calculates the relative rank of a row within a group of rows in SQL Server 2017. Use PERCENT_RANK to evaluate the relative standing of a value within a query result set or partition. PERCENT_RANK is similar to the CUME_DIST function. [PERMISSIONS] declaration=objectid,' column ' category=Security description=Returns a value containing a bitmap that indicates the statement, object, or column permissions of the current user. [PI] declaration= category=Mathematical description=Returns the constant value of PI. [POWER] declaration=float_expression,y category=Mathematical description=Returns the value of the specified expression to the specified power. [PUBLISHINGSERVERNAME] declaration= category=Replication description=Returns the name of the originating Publisher for a published database participating in a database mirroring session. This function is executed at a Publisher instance of SQL Server on the publication database. Use it to determine the original Publisher of the published database. [PWDCOMPARE] declaration=' clear_text_password ',password_hash,version category=Security description=Hashes a password and compares the hash to the hash of an existing password. PWDCOMPARE can be used to search for blank SQL Server login passwords or common weak passwords. [PWDENCRYPT] declaration=password category=Security description=Returns the SQL Server password hash of the input value that uses the current version of the password hashing algorithm. [QUOTENAME] declaration='character_string','quote_character' category=String description=Returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier. [RADIANS] declaration=numeric_expression category=Mathematical description=Returns radians when a numeric expression, in degrees, is entered. [RAND] declaration=seed category=Mathematical description=Returns a pseudo-random float value from 0 through 1, exclusive. [RANK] declaration=OVER ( [ partition_by_clause ] order_by_clause) category=Ranking description=Returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question. [REPLACE] declaration=string_expression,string_pattern,string_replacement category=String description=Replaces all occurrences of a specified string value with another string value. [REPLICATE] declaration=string_expression category=String description=Repeats a string value a specified number of times. [REVERSE] declaration=string_expression category=String description=Returns the reverse order of a string value. [RIGHT] declaration=character_expression,integer_expression category=String description=Returns the right part of a character string with the specified number of characters. [ROUND] declaration=numeric_expression,length,function category=Mathematical description=Returns a numeric value, rounded to the specified length or precision. [ROWCOUNT_BIG] declaration= category=System description=Returns the number of rows affected by the last statement executed. This function operates like @@ROWCOUNT, except the return type of ROWCOUNT_BIG is bigint. [ROW_NUMBER] declaration=PARTITION BY value_expression,order_by_clause category=Ranking description=Numbers the output of a result set. More specifically, returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. [RTRIM] declaration=character_expression category=String description=Returns a character string after truncating all trailing spaces. [SCHEMA_ID] declaration= category=Metadata description=Returns the schema ID associated with a schema name. [SCHEMA_NAME] declaration= category=Metadata description=Returns the schema name associated with a schema ID. [SCOPE_IDENTITY] declaration= category=Metadata description=Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, if two statements are in the same stored procedure, function, or batch, they are in the same scope. [SERVERPROPERTY] declaration=propertyname category=Metadata description=Returns property information about the server instance. [SESSIONPROPERTY] declaration=option category=Security description=Returns the SET options settings of a session. [SESSION_CONTEXT] declaration='key' category=System description=Returns the value of the specified key in the current session context. The value is set by using the sp_set_session_context (Transact-SQL) procedure. [SESSION_USER] declaration= category=Security description=SESSION_USER returns the user name of the current context in the current database. [SIGNBYASYMKEY] declaration=Asym_Key_ID,@plaintext,password category=Cryptographic description=Signs plaintext with an asymmetric key [SIGNBYCERT] declaration=certificate_ID,@cleartext,' password ' category=Cryptographic description=Signs text with a certificate and returns the signature. [SIGN] declaration=numeric_expression category=Mathematical description=Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression. [SIN] declaration=float_expression category=Mathematical description=Returns the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression. [SMALLDATETIMEFROMPARTS] declaration=year,month,day,hour,minute category=Date and time description=Returns a smalldatetime value for the specified date and time. [SOUNDEX] declaration=character_expression category=String description=Returns a four-character (SOUNDEX) code to evaluate the similarity of two strings. [SPACE] declaration=integer_expression category=String description=Returns a string of repeated spaces. [SQL_VARIANT_PROPERTY] declaration=expression,property category=Data type description=Returns the base data type and other information about a sql_variant value. [SQRT] declaration=float_expression category=Mathematical description=Returns the square root of the specified float value. [SQUARE] declaration=float_expression category=Mathematical description=Returns the square of the specified float value. [STATS_DATE] declaration=object_id,stats_id category=Metadata description=Returns the date of the most recent update for statistics on a table or indexed view. [STDEVP] declaration=ALL,DISTINCT,expression,OVER ( [ partition_by_clause ] order_by_clause) category=Aggregate description=Returns the statistical standard deviation for the population for all values in the specified expression. [STDEV] declaration=ALL,DISTINCT,expression,OVER ( [ partition_by_clause ] order_by_clause) category=Aggregate description=Returns the statistical standard deviation of all values in the specified expression. [STRING_AGG] declaration=expression,separator,<order_clause> category=String description=Concatenates the values of string expressions and places separator values between them. The separator is not added at the end of string. [STRING_ESCAPE] declaration=text,type category=String description=Escapes special characters in texts and returns text with escaped characters. STRING_ESCAPE is a deterministic function. [STRING_SPLIT] declaration=string,separator category=String description=Splits the character expression using specified separator. [STR] declaration=float_expression,length,decimal category=String description=Returns character data converted from numeric data. [STUFF] declaration=character_expression,start,length,replaceWith_expression category=String description=The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position. [SUBSTRING] declaration=expression,start,length category=String description=Returns part of a character, binary, text, or image expression in SQL Server. [SUM] declaration=ALL,DISTINCT,expression,OVER ( [ partition_by_clause ] order_by_clause) category=Aggregate description=Returns the sum of all the values, or only the DISTINCT values, in the expression. SUM can be used with numeric columns only. Null values are ignored. [SUSER_ID] declaration=' login ' category=Security description=Returns the login identification number of the user. [SUSER_NAME] declaration=server_user_id category=Security description=Returns the login identification name of the user. [SUSER_SID] declaration=' login ',Param2 category=Security description=Returns the security identification number (SID) for the specified login name. [SUSER_SNAME] declaration=server_user_sid category=Security description=Returns the login name associated with a security identification number (SID). [SWITCHOFFSET] declaration=DATETIMEOFFSET,time_zone category=Date and time description=Returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone offset. [SYMKEYPROPERTY] declaration=Key_ID,'algorithm_desc' category=Cryptographic description=Returns the algorithm of a symmetric key created from an EKM module. [SYSDATETIMEOFFSET] declaration= category=Date and time description=Returns a datetimeoffset(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offset is included. [SYSDATETIME] declaration= category=Date and time description=Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. [SYSTEM_USER] declaration= category=Security description=Allows a system-supplied value for the current login to be inserted into a table when no default value is specified. [SYSUTCDATETIME] declaration= category=Date and time description=Returns a datetime2 value that contains the date and time of the computer on which the instance of SQL Server is running. The date and time is returned as UTC time (Coordinated Universal Time). The fractional second precision specification has a range from 1 to 7 digits. The default precision is 7 digits. [TAN] declaration=float_expression category=Mathematical description=Returns the tangent of the input expression. [TERTIARY_WEIGHTS] declaration=non_Unicode_character_string_expression category=Collation description=For each character in a non-Unicode string expression - defined with a SQL tertiary collation - this function returns a binary string of weights. [TEXTPTR] declaration=column category=Text and Image description=Returns the text-pointer value that corresponds to a text, ntext, or image column in varbinary format. The retrieved text pointer value can be used in READTEXT, WRITETEXT, and UPDATETEXT statements. [TEXTVALID] declaration=table,column,text_ptr category=Text and Image description=A text, ntext, or image function that checks whether a specific text pointer is valid. [TIMEFROMPARTS] declaration=hour,minute,seconds,fractions,precision category=Date and time description=Returns a time value for the specified time and with the specified precision. [TODATETIMEOFFSET] declaration=expression category=Date and time description=Returns a datetimeoffset value that is translated from a datetime2 expression. [TRANSLATE] declaration=inputString,characters,translations category=String description=Returns the string provided as a first argument after some characters specified in the second argument are translated into a destination set of characters. [TRIGGER_NESTLEVEL] declaration=object_id,' trigger_type ',' trigger_event_category ' category=Trigger description=Returns the number of triggers executed for the statement that fired the trigger. TRIGGER_NESTLEVEL is used in DML and DDL triggers to determine the current level of nesting. [TRIM] declaration=characters,string category=String description=Removes the space character char(32) or other specified characters from the start or end of a string. [TRY_CAST] declaration=expression,data_type,length category=Conversion description=Returns a value cast to the specified data type if the cast succeeds; otherwise, returns null. [TRY_CONVERT] declaration=data_type [ ( length ) ],expression,style category=Conversion description=Returns a value cast to the specified data type if the cast succeeds; otherwise, returns null. [TRY_PARSE] declaration=string_value,data_type,culture category=Conversion description=Returns the result of an expression, translated to the requested data type, or null if the cast fails in SQL Server. Use TRY_PARSE only for converting from string to date/time and number types. [TYPEPROPERTY] declaration=type,property category=Metadata description=Returns information about a data type. [TYPE_ID] declaration=type_name category=Metadata description=Returns the ID for a specified data type name. [TYPE_NAME] declaration=type_id category=Metadata description=Returns the unqualified type name of a specified type ID. [UNICODE] declaration=' ncharacter_expression ' category=String description=Returns the integer value, as defined by the Unicode standard, for the first character of the input expression. [UPDATE] declaration=column category=Trigger description=Returns a Boolean value that indicates whether an INSERT or UPDATE attempt was made on a specified column of a table or view. UPDATE() is used anywhere inside the body of a Transact-SQL INSERT or UPDATE trigger to test whether the trigger should execute certain actions. [UPPER] declaration=character_expression category=String description=Returns a character expression with lowercase character data converted to uppercase. [USER] declaration= category=Security description=Allows a system-supplied value for the database user name of the current user to be inserted into a table when no default value is specified. [USER_ID] declaration=user category=Security description=Returns the identification number for a database user. [USER_NAME] declaration=id category=Security description=Returns a database user name from a specified identification number. [VARP] declaration=ALL,DISTINCT,expression,OVER ( [ partition_by_clause ] order_by_clause) category=Aggregate description=Returns the statistical variance for the population for all values in the specified expression. [VAR] declaration=ALL,DISTINCT,expression,OVER ( [ partition_by_clause ] order_by_clause) category=Aggregate description=Returns the statistical variance of all values in the specified expression. May be followed by the OVER clause. [VERIFYSIGNEDBYASYMKEY] declaration=Asym_Key_ID,clear_text,signature category=Cryptographic description=Tests whether digitally signed data has been changed since it was signed. [VERIFYSIGNEDBYCERT] declaration=Cert_ID,signed_data,signature category=Cryptographic description=Tests whether digitally signed data has been changed since it was signed. [XACT_STATE] declaration= category=System description=Is a scalar function that reports the user transaction state of a current running request. XACT_STATE indicates whether the request has an active user transaction, and whether the transaction is capable of being committed. [YEAR] declaration=date category=Date and time description=Returns an integer that represents the year of the specified date.
Close
