Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.

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.

CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.

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

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.