3> CREATE TABLE update_def
4> (
5> up_id int PRIMARY KEY,
6> up_byname varchar(30) NOT NULL DEFAULT SUSER_SNAME()
7> CHECK (up_byname=SUSER_SNAME())
8> -- Assume other columns would be here
9> )
10> GO
1>
2> UPDATE update_def
3> SET
6> up_byname=DEFAULT
7> WHERE up_id=1
8> GO
(0 rows affected)
1>
2> drop table update_def;
3> GO