Date functions in SQL Server are used to perform various operations on date and timestamp data stored in the database. They allow for manipulation, extraction, formatting, and calculation of dates and ...

Function with Input Parameter in SQL Server In SQL Server, you can create functions that accept input parameters, allowing you to pass values to the function and perform operations based on those ...

In SQL Server 2014 we saw the introduction of Natively Compiled Stored Procedures. In 2016 we’ll be able to do the same for Scalar User Defined Functions.

To encrypt and decrypt a string we have a predefined functions in sql server 2008 that are easy to use. suppose we want to save some data that doesn't need to be exposed as a plain text then in such ...

Using the CLR Function 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 ...

Azure recently announced the public preview of Azure SQL trigger for Azure Functions to build event-driven applications. The new functionality is currently available only for C# functions and can ...