how do you insert null values into sql server

问题:

In sql server enterprise manager, how do you write an insert statement and pass in null values?

回答1:

INSERT INTO atable (x,y,z) VALUES ( NULL,NULL,NULL)

回答2:

If you're using SSMS (or old school Enterprise Manager) to edit the table directly, press CTRL+0 to add a null.