在SQL Server中设置日期

CREATE TABLE MyTable (
    ID INT PRIMARY KEY,
    Name NVARCHAR(50),
    Date DATE
);

INSERT INTO MyTable (ID, Name, Date)
VALUES (1, 'John Doe', '2022-01-01');

SELECT * FROM MyTable WHERE Date = '2022-01-01';

UPDATE MyTable SET Date = '2022-01-02' WHERE ID = 1;

ALTER TABLE MyTable ALTER COLUMN Date DATE NULL;

UPDATE MyTable SET Date = NULL WHERE ID = 1;