DataTypes

Technical Article

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)

You rated this post out of 5. Change rating

2014-04-07 (first published: )

1,540 reads

External Article

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?

2012-09-04

2,480 reads

Blogs

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

By

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...

Set-Based vs Row-Based Database Code

By

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...

Read the latest Blogs

Forums

The Fake Speakers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Fake Speakers

Stairway to Database DevOps Level 3: Managing Code as a Team in Git

By Erin Dempster

Comments posted to this topic are about the item Stairway to Database DevOps Level...

Reduction of installation time of sql server 2008 R2 Express

By IT researcher

The installation of SQL Server 2008 R2 Express on a virtual machine takes around...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers