how do you insert null values into sql server

Question

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

score 114 · Accepted Answer · answered Jul 19 '09 at 11:06

114

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

answered Jul 19 '09 at 11:06

mattmc3 · Answer 2 · 2012-09-12T17:18:55.363

64

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

edited Sep 12 '12 at 17:18

answered Oct 17 '09 at 03:10

mattmc3

2 Answers2