How do I insert a null value into a date column?
How do I insert a null value into a date column? "NULL" can be specified as a value in the Date field to get an empty/blank by using INSERT statement. Example: CREATE table test1 (col1 date); INSERT into test1 values (NULL); Can we insert null in DateTime SQL Server? Or, you can make use of the DEFAULT constaints: DateTimeColumn DateTime DEFAULT NULL, @OziOz If this datetime fild is defined as DateTimeColumn DateTime DEFAULT NULL , just ignore it in the insert columns' list and it will be inserted with NULL value. Can you insert a null value in SQL? You...