declaring datatypes

Question

Post reply

declaring datatypes

SVDURGA

SSC Journeyman

Points: 88
More actions
July 25, 2010 at 10:21 pm

#221648

which datatype is suitable for 'HSUB 9N380800 1010000.000000 USD' data in sql_server

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

I feel VARCHAR would suite this.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Is that a single attribute or 4 different values that need storing?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SVDURGA SSC Journeyman Points: 88 More actions · Answer 3

Thanks fro response. What i have mentioned in above is single line.

thx

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

I can see it's a single line. What I'm asking is whether that should be a single column or multiple. It looks like there are multiple things in there. If so, they should be stored in separate columns, not stuffed into one.

Database design - first normal form - all attributes should be atomic (cannot be broken down)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 5

How are you going to name this column?

If it's Comments then varchar can be used.

If it's intended be "Details", then follow Gail advise and split it into separate columns, for example:

SomeCode CHAR(4),

AnotherCode CHAR(8),

Amount DECIMAL(19,6),

CurrencyCode CHAR(3)

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

SVDURGA SSC Journeyman Points: 88 More actions · Answer 6

Thanks for your response.

In my requirement table has some columns among one column name is

TRANSACTION_DESCRIPTION

HSUB 9N350820 1010000.000000 USD

HSUB 9N380800 1010000.000000 USD

HSUB 9N381500 1010000.000000 USD

HSUB 9N383290 1010000.000000 USD

Above are the values under the column TRANSACTION_DESCRIPRTION.

THX.

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 7

Then VARCHAR. Give it some relevant size based on sample of data you have. It looks like extract from other system, so you may ask for specification describing maximum length for this field...

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

SVDURGA SSC Journeyman Points: 88 More actions · Answer 8

SVDURGA

SSC Journeyman

Points: 88

July 26, 2010 at 10:33 am

#1198299

Thank you.