2 ways to enter a null value in SSMS

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).

 

 

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s