If you only need to provide a value for this column
10>
11> CREATE TABLE Product (
12> Name nchar (5) NOT NULL
13> )
14> GO
1>
2> INSERT INTO Product (Name) SELECT 'Wid'
3> GO
(1 rows affected)
1>
2> select * from Product;
3> GO
Name
-----
Wid
(1 rows affected)
1>
2> drop table Product;
3> GO
1>