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

Content with tag String Rss

   Items 1 to 8 of 8   
 

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: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,429 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: SQLServerCentral.com | Category: variables
Rating: |  Discuss |   Briefcase | 3,273 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 2012/04/09 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 1,786 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: SQLServerCentral.com | Category: string
Rating: (not yet rated) |  Discuss |   Briefcase | 752 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: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 2,627 reads

Triming String

This function is used to trim the input string  Read more...
By xaprios 2013/06/18 | Source: SQLServerCentral.com | Category: trim
Rating: (not yet rated) |  Discuss |   Briefcase | 164 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 2013/06/18 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 298 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: SQLServerCentral.com | Category: variables
Rating: |  Discuss |   Briefcase | 3,273 reads
   Items 1 to 8 of 8   
 
Tags
search (4)    
find (3)    
text (2)    
aggregates (1)    
character (1)    
columns (1)    
data (1)    
definition (1)    
delimited (1)    
find string (1)    
find text (1)    
locate string (1)    
lookup (1)    
search text (1)    
sqlclr (1)    
trim (1)    
varchar (1)    
variables (1)    
word (1)