By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

how to solve the following

P: 1
Hi every one!

I an new in sql so please dont explain with the big words.
My main problem is, i have a table that i want to change data types in certain columns.
Here is the code that i have used

USE [ShearAcTraining]
ALTER TABLE Aircraftmodels
ALTER COLUMN @Speed int,
ALTER COLUMN @Costpermile int,
ALTER COLUMN @FuelConsumption int,
ALTER COLUMN @NoSeats int,
ALTER COLUMN @AllUpWeight int,
ALTER COLUMN @AUWRounded int,
ALTER COLUMN @NoEngines int,
ALTER COLUMN @CurrentUser nvarchar(50),
ALTER COLUMN @EntryDate datetime

It brings me an error message that states

Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '@Speed'.

Please tell me where i could be going wrong and how to solve search problems
Feb 4 '10 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
The symbol "@" tells SQL Server that it's a variable, not a column name. Here, read this

Good Luck!!!

~~ CK
Feb 4 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.