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

Content with tag text Rss

   Items 1 to 8 of 8   
 

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: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 4,082 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: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 4,082 reads

Full Text Searches on Documents in FileTables

SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex searches. As with most technologies, the best way of learning them is to try it out and experiment. Feodor shows how to set it up, add some sample data and set up full-text search.  Read more...
By Additional Articles 2013/02/26 | Source: SimpleTalk | Category: text
Rating:  Rate this |   Briefcase | 1,849 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,622 reads

Function to calculate and return age in text to closest minute between

Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes  Read more...
By Shane Clarke 2012/06/05 | Source: SQLServerCentral.com | Category: age
Rating: |  Discuss |   Briefcase | 976 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: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 4,082 reads

Generate alter datatype script for entire database

ntext, text, and image (Transact-SQL). This script will alter the data type from image to varbinary(max) which is very much required as the data type is out of support.  Read more...
By Venugopal Saride 2011/11/28 | Source: SQLServerCentral.com | Category: ntext
Rating: |  Discuss |   Briefcase | 818 reads

Just for fun

Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.  Read more...
By Peter Sloboda 2010/09/03 | Source: SQLServerCentral.com | Category: word
Rating: |  Discuss |   Briefcase | 2,584 reads
   Items 1 to 8 of 8   
 
Tags
columns (2)    
find (2)    
search (2)    
string (2)    
word (2)    
age (1)    
alter (1)    
change column (1)    
character (1)    
data (1)    
data types (1)    
function (1)    
funny (1)    
image (1)    
lookup (1)    
ntext (1)    
random (1)