data type for storing 100 C value

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 2005 Forums

Transact-SQL (2005)

data type for storing 100 C value

Author

Topic

learntsql

524 Posts

Posted - 2010-09-08 : 03:39:24

Hi All,
What datatype should i use to store 100 crore value.

jafrywilson
Constraint Violating Yak Guru

379 Posts

Posted - 2010-09-08 : 03:54:15

What data?

learntsql

524 Posts

Posted - 2010-09-08 : 03:56:00

its numerical data. like phone number

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-09-08 : 05:13:26

quote:
Originally posted by learntsql

its numerical data. like phone number

If you have special characters like + or - use varchar

Madhivanan

Failing to plan is Planning to fail

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-09-08 : 21:28:07

quote:
Originally posted by madhivanan

quote:
Originally posted by learntsql

its numerical data. like phone number

If you have special characters like + or - use varchar

Madhivanan

Failing to plan is Planning to fail

why not a decimal data type ?

KH
[spoiler]Time is always against us[/spoiler]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-09-09 : 03:57:33

quote:
Originally posted by khtan

quote:
Originally posted by madhivanan

quote:
Originally posted by learntsql

its numerical data. like phone number

If you have special characters like + or - use varchar

Madhivanan

Failing to plan is Planning to fail

why not a decimal data type ?

KH
[spoiler]Time is always against us[/spoiler]

If the values like these to be stored

+91962816385
91-976672345

Madhivanan

Failing to plan is Planning to fail

learntsql

524 Posts

Posted - 2010-09-09 : 04:33:10

Thanks for ur replies..
When i am using varchar its storing as
90324e+456
like this.
What would be the reason.
TIA.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-09-13 : 05:29:21

quote:
Originally posted by learntsql

Thanks for ur replies..
When i am using varchar its storing as
90324e+456
like this.
What would be the reason.
TIA.

How do you insert data to the column?

Madhivanan

Failing to plan is Planning to fail

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-09-13 : 08:38:30

100 crore = 1,000,000,000 ?

Just use a numeric data type like decimal(20)

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources