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

Scripts with tag text Rss

Search for any content tagged text

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

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,646 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: | Category: age
Rating: |  Discuss |   Briefcase | 983 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: | Category: string
Rating: |  Discuss |   Briefcase | 4,458 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: | Category: ntext
Rating: |  Discuss |   Briefcase | 831 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: | Category: word
Rating: |  Discuss |   Briefcase | 2,598 reads
   Items 1 to 5 of 5