• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

A 10 seconds SQL error

New to SQL, really simple error, please help to see why the error


Create Table Test2BDeleted233
(UnitPrice as money,
Quantity as int,
SubTotal as UnitPrice * Quantity)


   Msg 102, Level 15, State 1, Line 2
   Incorrect syntax near ')'.
1 Solution
Steve WalesSenior Database AdministratorCommented:
Try: (remove the "as" from columns 1 and 2)

Create Table Test2BDeleted233
(UnitPrice money,
Quantity int,
SubTotal as UnitPrice * Quantity) 

Open in new window

TickTechAuthor Commented:
Yes, it works. Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now