2 ways to enter a null value in SSMS

markblomsma Database

Sometimes simple things are hard to remember, so if you ever want to enter a null value when editing table data using SQL Server Management Studio, then remember that there are 2 options to do it:

  1. Copy and paste a NULL value from another field;
  2. Enter CTRL+0 (control zero).

 

 

One thought on “2 ways to enter a null value in SSMS”

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s