CODEWITHSUNDEEP
sqlsql-servernull
leora
leora

Reputation: 196459

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?

Upvotes: 80

Views: 249314

Answers (2)

mattmc3
mattmc3

Reputation: 18325

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

Upvotes: 64

anon
anon

Reputation: 

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

Upvotes: 116

Related Questions