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,394 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,269 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,764 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 | 749 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,616 reads

Triming String

This function is used to trim the input string  Read more...
By xaprios 2013/05/19 | Source: SQLServerCentral.com | Category: trim
Rating: (not yet rated) |  Discuss |   Briefcase | 163 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/05/19 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 293 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,269 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)