SQLServerCentral.com Scripts tagged text

Search for String in all columns

Wed, 07 Nov 2012 07:00:00 UT

Find all columns containing a string value across all tables and schemas.

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

Tue, 05 Jun 2012 06:00:00 UT

Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes

String Search

Mon, 09 Apr 2012 06:00:00 UT

Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.

Generate alter datatype script for entire database

Mon, 28 Nov 2011 07:00:00 UT

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.

Just for fun

Fri, 03 Sep 2010 06:00:00 UT

Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.