views:

1370

answers:

2

in sql server enterprise manager, how do you write an insert statement with passing in null values

+7  A: 
INSERT INTO atable (x,y,z) VALUES ( NULL,NULL,NULL)
anon
+1  A: 

If you're using Enterprise Manager to edit the table directly, press CTRL+0 to add a null.

mattmc3
Excellent - I always forget this!
Jarrod Dixon