Click here to monitor SSC
SQLServerCentral is supported by Redgate
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,770 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,732 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 2015/12/24 | Source: | Category: string
Rating: |  Discuss |   Briefcase | 5,712 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 | 817 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,854 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 | 192 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 | 342 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,362 reads
   Items 1 to 8 of 8