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
 General SQL Server Forums
 New to SQL Server Programming
 create table: want a column with money data type

Author  Topic 

landau66
Yak Posting Veteran

61 Posts

Posted - 2007-12-14 : 09:45:37
Hi all!

I want to create a table. One of the columns should be in the data type MONEY with two digits on the right side of the decimal point.
How is that possible?

Thanks a lot and greetings from vienna

landau

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-12-14 : 09:57:09
[code]Create Table sometable
(
MoneyCol Numeric(25,2),
... --other columns here
)[/code]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

landau66
Yak Posting Veteran

61 Posts

Posted - 2007-12-15 : 11:43:32
thanx a lot
Go to Top of Page
   

- Advertisement -