Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 DataType of a T-SQL Variable

Author  Topic 

ManishChandra.jiit
Starting Member

1 Post

Posted - 2010-05-24 : 07:58:35
How can I get a textual description of the data type of a T-SQL Variable?

!! Rise & Shine !!

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-05-24 : 09:24:41
what is a textual description?
Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-05-24 : 11:14:23
Take a look at the INFORMATION_SCHEMA.Columns view. There is a column called DATA_TYPE that might be what you are looking for.
Go to Top of Page
   

- Advertisement -