SQLServerCentral.com Scripts tagged String

Search for String in all columns

Wed, 07 Nov 2012 07:00:00 UT

Find all columns containing a string value across all tables and schemas.

String Search

Mon, 09 Apr 2012 06:00:00 UT

Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.

CLR Aggregate to Concatenate delimited strings

Thu, 27 Jan 2011 07:00:00 UT

One must be carefull unless the input is sorted by the value passed to the function and there is no paralelism there is no guarantee that the resulting value will be sorted.

Search all tables for text

Mon, 15 Feb 2010 07:00:00 UT

This script will help you search all tables for a specific set of text.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Triming String

Wed, 25 Feb 2009 08:59:28 UT

This function is used to trim the input string

Find a string in compiled objects

Sat, 01 Nov 2008 02:27:12 UT

This utility will find strings in procedures, functions, views, and even check constraints.

Insert multiple rows into variable

Thu, 17 May 2012 06:00:00 UT

This is a very useful trick for working with variables.