且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQL Server 插入日期为 1/1/1900

更新时间:2022-06-05 22:42:22

您没有将其指定为 null,您正试图插入一个空字符串 ('').您需要:

You have not given it as null, you're trying to insert an empty string (''). You need:

INSERT INTO [ABC] ([code],[updatedate],[flag],[Mfdate]) 
VALUES ('203', '6/12/2013','N/A', NULL) 

尽管实际上,如果您要插入日期,***以 YYYYMMDD 格式插入它们,例如:

Although really, if you're going to be inserting dates, best to insert them in YYYYMMDD format, as:

INSERT INTO [ABC] ([code],[updatedate],[flag],[Mfdate]) 
VALUES ('203', '20130612','N/A', NULL)