SQL Table Creation Default Value = 0

[shane1]

Could someone tell me how to set the Default Value = 0 in SQL Server 2000. I am using an Access 97 front end. I recently converted our Access 97 back end to SQL Server 2000. How do I set the default value = 0 in SQL Server 2000.
Any help would be appreciated....

 

[nigelrivett]

create table tbl
(
i int default 0
)


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[nigelrivett]

or if the column is already there and you want to ad a default

alter table tbl add default 0 for i


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.