Identify Column Data Types

  • Script

Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.

2.67 (3)

2014-04-07 (first published: )

1,261 reads

SQL Server Data Type Precedence

  • Article

I am executing a simple query/stored procedure from my application against a large table and it's taking a long time to execute. The column I'm using in my WHERE clause is indexed and it's very selective. The search column is not wrapped in a function so that's not the issue. What could be going wrong?


2,480 reads


Code from Redgate Streamed


I presented a session today at Redgate Streamed and did a number of demos....

Daily Coping–2 Apr 2020


I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Learn SSIS and ADF for Free


It’s not from SQLServerCentral, though I hope to do more training across the next...

Read the latest Blogs


Veeam backups and Transaction Log truncation

By UgBug

The hospital that I work for has started to use Veeam for backing up...

Temporary turn off Transactional Replication?

By jbalbo

Hi We get a DB that is replicated every 10 seconds or so We...

mass null replace in a query.

By Lee Hopkins

I have some data that i have no control over (third party supplying the...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers