Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Scripts with tag String Rss

Search for any content tagged string

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 8 of 8   

Split and concatenate function

Function for splitting the values in string, applying logic and concatenating back to string.  Read more...
Rating: |  Discuss |   Briefcase | 1,720 reads

Search for String in all columns

Find all columns containing a string value across all tables and schemas.  Read more...
By Wes Henriksen 2012/11/07 | Source: | Category: search
Rating: |  Discuss |   Briefcase | 1,698 reads

String Search

Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.  Read more...
By Sean Smith 2014/10/22 | Source: | Category: string
Rating: |  Discuss |   Briefcase | 4,600 reads

CLR Aggregate to Concatenate delimited strings

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.  Read more...
By Gokhan Varol 2011/01/27 | Source: | Category: string
Rating: (not yet rated) |  Discuss |   Briefcase | 801 reads

Search all tables for text

This script will help you search all tables for a specific set of text.  Read more...
By Luis Chiriff 2010/02/15 | Source: | Category: search
Rating: |  Discuss |   Briefcase | 2,833 reads

Triming String

This function is used to trim the input string  Read more...
By xaprios 2009/02/25 | Source: | Category: trim
Rating: (not yet rated) |  Discuss |   Briefcase | 190 reads

Find a string in compiled objects

This utility will find strings in procedures, functions, views, and even check constraints.  Read more...
By David Korb 2008/10/31 | Source: | Category: search
Rating: |  Discuss |   Briefcase | 336 reads

Insert multiple rows into variable

This is a very useful trick for working with variables.  Read more...
By Megan Beebe 2012/05/17 | Source: | Category: variables
Rating: |  Discuss |   Briefcase | 3,352 reads
   Items 1 to 8 of 8