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 2000 Forums
 SQL Server Development (2000)
 Numeric and Int Data Types

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-05 : 09:10:05
Fortunate Guy writes "Whats the difference between the datatype "NUMERIC" and "INT" in SQL Server ?"

Nazim
A custom title

1408 Posts

Posted - 2002-02-05 : 09:54:41
Integer can store only integer values and its size is fixed , it takes 4 bytes.
where as with Numeric you can custom create your fields to store precision values and as well as you determine the storage size.

Check BooksOnline for furthur Information.

--------------------------------------------------------------
Dont Tell God how big your Problem is , Tell the Problem how Big your God is
Go to Top of Page
   

- Advertisement -