This gives an error 1

[compu66]

Hi,

I am adding a constraint while modifying the dbtype.

ALTER TABLE Exams Alter Column WLUs float null
CONSTRAINT DF_Exams_WLUs DEFAULT (0) for WLUs

This gives an error saying "incorrect syntax near constraint"

So i wrote it as
ALTER TABLE Exams Alter Column WLUs float null
ALTER TABLE Exams add CONSTRAINT DF_Exams_WLUs DEFAULT (0) for WLUs

Then it worked but I want in the first pattern,I dont want to write "alter table exam" twice just to add constraint

Thanks for the help in advance

 

[gmmastros]

Sometimes you don't get what you want.

Seriously, there's no other way to do it.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[compu66]

Hey I liked ur way of answering.
Thanks.

 

[onpnt]

[sub]____________ signature below ______________
Backups are for sissies!!!!

http://www.lessthandot.com

coming to your keyboards soon[/sub]

 

[SQLSister]

You do know that floats are inexact datatypes and shouldn't be used if you plan to do any math with the numbers or you will getting rounding errors.

"NOTHING is more important in a database than integrity." ESquared

 

[LNBruno]

Floats are for boats!

< M!ke >
[small]Don't believe everything you think.[/small]