As developer in Microsoft technology we all need to know about data types supported by the sql server 2000 and sql serve 2005. We also have to know what is there ranges and where it should use.
I have found a cool link that describes all the things above.
here is the link for that article...
http://www.teratrax.com/sql_guide/data_types/sql_server_data_types.html