Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined function. See Figure 1 for a ...

This sample shows how to create REST API using Azure Function that read data from Azure SQL Database using FOR JSON clause. To run this sample, you need to download source code from SQL Server GitHub ...

Scenario 1: Generate .txt files from data currently stored in Azure SQL Database and send the files to an FTP server Scenario 2: Take data from the Azure SQL Database and send the data to an API ...

This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server. A release the magnitude of SQL Server 2016 deserves a new sample. AdventureWorks, which has been around since the SQL ...

To encrypt and decrypt a string we have a predefined functions in Sql Server 2008 that are easy to use ... Key@12',@EncryptedString)) AS 'Decrypted String' Here is a sample of practical use to save ...

In SQL Server, a function that returns a single value is ... as deterministic or non-deterministic by the database. An example of a non-deterministic function would be one that reads the current ...

Consider the following function. It connects to the DimDate table in the Adventure Works DW sample database for SQL Server, removes all but the Date, Day, Month and Year columns, and allows you to ...