how to solve the following

[kanyash]

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

[ck9663]

The symbol "@" tells SQL Server that it's a variable, not a column name. Here, read this

Good Luck!!!

~~ CK