ADD MASKED WITH (FUNCTION = ' mask_function ') Applies to: SQL Server 2016 (13.x) and later, SQL Database. Specifies a dynamic data mask. mask_function is the name of the masking function with the appropriate parameters. The following functions are available: default() email() partial()...
The examples in this section show how to retrieve permissions information.A. Return the complete list of grantable permissionsThe following statement returns all Database Engine permission by using the fn_builtin_permissions function. For more information, see sys.fn_builtin_permissions (Transact-SQL...
The documentation for each function that must run exclusively on the leader node includes a note stating that the function will return an error if it references user-defined tables or Amazon Redshift system tables. SeeLeader node–only functionsfor a list of functions that run exclusively on the...
Code examples ExampleDescription Proof of concept connecting to SQL with RubyA small code example focused on connecting and querying SQL Server. Azure SQL database: Use Ruby to queryAzure SQL Database example. Other development This section provides links about other development options. These include...
Examples A. Return maximum value from a list of constants The following example returns the maximum value from the list of constants that is provided. The scale of the return type is determined by the scale of the argument with the highest precedence data type. ...
The solution in this tutorial requires you to create three virtual machines: two with SQL Server instances and one that functions as a witness. Windows Server 2016 can use acloud witness. But for consistency with previous operating systems, this article uses a...
The ODBC function {fn CONVERT()} uses the default date format of the language. For some languages, the default format is YDM, which can result in conversion errors when CONVERT() is combined with other functions, such as{fn CURDATE()}, that expect a YMD format.The ODBC function{fn CONVE...
Examples A. Using both CAST and CONVERT Each example retrieves the name of the product for those products that have a 3 in the first digit of their list price and converts their ListPrice to int. Copy -- Use CAST USE AdventureWorks2012; GO SELECT SUBSTRING(Name, 1, 30) AS ProductName...
PDF Amazon Kinesis Data Analytics provides a number of Functions, and also allows users to extend its capabilities by means of user-defined functions (UDFs). Amazon Kinesis Data Analytics supports UDFs defined in SQL only. User-defined functions may be invoked using either the fully-qualified name...
With minimal logging, using the SELECT...INTO statement can be more efficient than creating a table and then populating the table with an INSERT statement. For more information, see The Transaction Log (SQL Server). SELECT...INTO statements that contain user-defined functions (UDFs) are fully...