ALTER TABLE using money? - SQL Server Forums

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

SQL Server Development (2000)

ALTER TABLE using money?

Author

Topic

Woodzy
Starting Member

7 Posts

Posted - 2005-01-17 : 20:25:31

Hello,
I'm trying to add a column to a table using the money variable
EX:
ALTER TABLE Movies
ADD Price money (8) NOT NULL
DEFAULT '3.00'

ERROR Message: Server: Msg 2716, Level 16, State 1, Line 330
Column or parameter #7: Cannot specify a column width on data type money.

Thanks, Woodzy

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-01-17 : 23:43:14

Try this


ALTER TABLE Movies
ADD Price money NOT NULL
DEFAULT 3.00

Madhivanan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources