Posted by othellomy on 11/13/06 07:04

Also, SQL server defaults to 'allow nulls' when creating tables. (It
usually is when nothing is specified then 'not null' is default value).
for example;
create table t1(c1 int, c2 int)
insert t1(c1) values(0)

select * from t1
c1 c1
0 null

• Next in forum: Re: 200611 to string 'Nov 2006'
• Prev in forum: Re: case sensitivity
• Thread view: default is NULL

[Reply to this message]