problem with bigint data type - SQL Server Forums

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

Transact-SQL (2000)

problem with bigint data type

Author

Topic

elvio
Starting Member

1 Post

Posted - 2006-02-08 : 21:18:05

hello everyone, i am new to SQL hope u guys dont mind. :)

in microsoft SQL server 2000,
integer data stored using data type below:-
-bigint
-int
-smallint
-tinyint

my problem is:

For the bigint
how to cope the problem if my integer data to be stored are larger then it can affort,any solution??

Regards,
Elvio

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-02-08 : 22:47:11

Must be big numbers you are dealing with to be larger than BIGINT.

You can have up to 38 digits in a NUMERIC(38,0) datatype.


select
	BIG_INT = convert(bigint,0x7FFFFFFFFFFFFFFF) ,
	BIG_NUM =
	convert(numeric(38,0),99999999999999999999999999999999999999)



BIG_INT              BIG_NUM                                  
-------------------- ---------------------------------------- 
9223372036854775807  99999999999999999999999999999999999999

(1 row(s) affected)

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources