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 12 of 12   
 

Comparing Different Data Types

Comparing columns of different data types can be a drain on resources, as well as our sanity. This is a look into a few strategies for dealing with implicit conversions.  Read more...
By Edward Pollack 2014/05/19 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 6,126 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 2013/11/28 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 3,129 reads

Datetime conversion of empty string

By Gabe Tower 2013/11/25 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 2,115 reads

Split and concatenate function

Function for splitting the values in string, applying logic and concatenating back to string.  Read more...
Rating: |  Discuss |   Briefcase | 1,592 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: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,619 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,329 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 2013/11/28 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 3,129 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 | 784 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,771 reads

Triming String

This function is used to trim the input string  Read more...
By xaprios 2009/02/25 | Source: SQLServerCentral.com | Category: trim
Rating: (not yet rated) |  Discuss |   Briefcase | 185 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: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 326 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,329 reads
   Items 1 to 12 of 12   
 
Tags
search (4)    
find (3)    
t-sql (3)    
text (2)    
aggregates (1)    
character (1)    
columns (1)    
concatenate (1)    
data (1)    
data types (1)    
datetime (1)    
definition (1)    
delimited (1)    
find string (1)    
find text (1)    
function (1)    
implicit conversion (1)    
locate string (1)    
lookup (1)    
optimization (1)    
performance tuning (1)    
split (1)    
sqlclr (1)    
trim (1)    
varchar (1)    
variables (1)    
word (1)