Decimal data type: storage in bytes?
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Free Databases support forum > Microsoft SQL server > SQL Server > Decimal data type: storage in bytes?




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    Decimal data type: storage in bytes?  
Don


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
05-06-04 06:36 PM

SQL 7.0

What is the storage in bytes of decimal data type?

Thanks,
Don






[ Post a follow-up to this message ]



    Re: Decimal data type: storage in bytes?  
Narayana Vyas Kondreddi


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
05-06-04 06:36 PM

Depends on the precision you want. Can go from 5 to 17 bytes. Look up the
topic "decimal and numeric (T-SQL)" in SQL Server 7.0 or 2000 Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm




"Don" <anonymous@discussions.microsoft.com> wrote in message
news:95ff01c4338d$ae53cf70$a501280a@phx.gbl...
SQL 7.0

What is the storage in bytes of decimal data type?

Thanks,
Don








[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 12:53 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register