Smallmoney data type size? DTS

#1

To all gurus I have a text file getting in via dts into sql server there
are 43 columns in the create table statement with 15 being of the type
small money. How many spaces does smallmoney take ???

Will

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

#2

In article <ejKoMackDHA.2404 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Will_2112
<anonymous (AT) devdex (DOT) com> writes

Quote:

To all gurus I have a text file getting in via dts into sql server there
are 43 columns in the create table statement with 15 being of the type
small money. How many spaces does smallmoney take ???

Will

From Books Online, smallmoney-

Monetary data values from - 214,748.3648 through +214,748.3647, with
accuracy to a ten-thousandth of a monetary unit. Storage size is 4
bytes.

It doesn't take any spaces. If you are importing a fixed width file,
then it is up to you to specify the "width".

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Smallmoney data type size? DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Smallmoney data type size? DTS - 10-13-2003 , 03:14 PM

Re: Smallmoney data type size? DTS - 10-13-2003 , 04:08 PM