Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

This PowerShell module contains two functions that are useful for exporting large amounts of data from tables, views, or queries on an (Azure) SQL Server database into CSV files compliant with the RFC ...

Joey on SQL Server SQL Server 2022: Every Licensing Detail You Need To Know Microsoft's relational database engine has had the same licensing model since 2012.

Finally, SQL Server does have a CONCAT_WS function, which is more or less a non-aggregate version of STRING_AGG. It's only available since SQL Server 2017, but we should translate string.Join to it ...

Function inlining in SQL Server 2019 Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. This means they will be folded into the query and no longer incur the UDF ...

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 ...

Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.