about different data types in MS Sql Server 2005

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

General SQL Server Forums

New to SQL Server Programming

about different data types in MS Sql Server 2005

Author

Topic

jonekim
Starting Member

35 Posts

Posted - 2011-04-12 : 22:52:51

I am new to database designing. I want to know about different data types in Microsoft SQL Server 2005.
1. bigint
2. binary(50)
3. nchar
4. ntext vs text
5. numeric
6. nvarchar
7. datetime vs smalldatetime
8. smallmoney vs money
9. sql_variant
10. timestamp

What are the appropriate use of such datatypes, I mean suppose when to use nvarchar and when to use ntext??

McDebil
Starting Member

23 Posts

Posted - 2011-04-13 : 01:06:03

Read the Books Online about the datatypes. Wery good documentation.

McDebil

Ranjit.ileni
Posting Yak Master

183 Posts

Posted - 2011-04-13 : 06:55:04

you can find SQL Server 2005 datatypes info in
http://msdn.microsoft.com/en-us/library/ms187752(v=SQL.90).aspx

--Ranjit

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources