var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alter Column Set Default
I've done some research on setting the default value of a column and found the following code:
ALTER TABLE [table1] ALTER COLUMN [column1] SET DEFAULT 0
I am trying to set column1 within table1 to a default value of 0, column1 is an int data type. But it doesn't work within MS SQL SERVER 2000.
Can anyone tell me what's wrong?
what you want is this:
ALTER TABLE table1
ADD CONSTRAINT DF_table1_column1
DEFAULT 0 FOR column1
Thanks very much! It's appreciated.