Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

A 10 seconds SQL error

Posted on 2014-04-20
2
Medium Priority
?
260 Views
Last Modified: 2014-04-20
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)



------------------------------------------------------
Message:

   Msg 102, Level 15, State 1, Line 2
   Incorrect syntax near ')'.
0
Comment
Question by:TickTech
2 Comments
 
LVL 23

Accepted Solution

by:
Steve Wales earned 2000 total points
ID: 40011919
Try: (remove the "as" from columns 1 and 2)

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

Open in new window

0
 

Author Comment

by:TickTech
ID: 40011920
Yes, it works. Thanks!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question