We frequently use some datatypes like INT, CHAR, VARCHAR,etc. But there are currently 37 datatype supported by SQL Server. If you want to know the list of supported datatype, run the following methods
Method 1 : Use system stored procedure sp_datatype_info
exec sp_datatype_info
Method 2 : Use system table sys.types
select * from sys.types
There are other system stored procedures specific to each versions
Version 2005
exec sp_datatype_info_90
Version 2008
exec sp_datatype_info_100
Tags: t-sql, sql_server, sqlserver, tsql, BRH, DataTypes, #TSQL, #SQLServer,
Madhi sir, Eventhough am having sql server 2005 the SPs are not found.. pls tell me y its happening so..i dont know whether anything may get dropped...
the default SPs are not woking... y so..
Haripriya ,
What did you mean by "default stored procedure"?
This is great. Useful if one does not have BOL handy to see what data-types are supported by a given version.
Thanks for sharing, Madhivanan!
Thanks for the feedback Nakul