Cool Tips‎ > ‎

Data Type

 

Title

Description

Applicability

 

Get all Column Names and Data Types    

Retrieves column names and basic data type information for one or all tables in the curent database. 

 

2000, 2005, 2008, 2008R2, 2012

 

Check if String is All Digits

 

An elegant implementation of a simple ISINTEGER() function. 

 

2000, 2005, 2008, 2008R2, 2012

 

Check Collation Settings

 

Checks for collation mismatches at the server, database and object levels.

 

2000, 2005, 2008, 2008R2, 2012

 

Get String Composition

 

Return a summary of the types of characters that the input string is composed of.

 

2000, 2005, 2008, 2008R2, 2012

 

Convert all Database Objects to UNICODE

Dynamically generates an extensive ordered script to change all text-based columns in a database to use UNICODE.

 

2000, 2005, 2008, 2008R2, 2012

 

 

 

Comments