insert into 的问题 在数据库中,为什么用insert 向datetime 字段中插入空值时默认是1900-01-01,能否为空

---------------------------------------------------------------

可以为空,见下例:
create table aaa (
tt datetime )
on [primary]

insert into aaa (tt) values (null)

select * from aaa

tt
---------------------------
NULL

(1 row(s) affected)

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus