CLR functions that perform string manipulation and substring extraction perform very well in SQL Server. By Joe Kunk; 10/11/2011; Recently I encountered a problem in a stored procedure that was caused ...

By changing the string into XML, each part between the delimiters becomes a separate XML element. This method gives better control over complex delimiters, supports multi-character delimiters, and ...

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

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.

Below is a cheat sheet for creating SQL Server client connection strings and finding them in common configuration files. Connecting to instances by name, forcing a named pipes connection.

If the ordinal output column isn't enabled, STRING_SPLIT returns a single-column table whose rows are the substrings. The name of the column is value.It returns nvarchar if any of the input arguments ...

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

Dynamic SQL lets you create a query string based off of user input. SQL Server allows ... Click "Microsoft SQL Server," then click "SQL ... function. The following code executes the SQL ...