<< Items collection must be empty before using ItemsSource | Adding a unique constaint to a column that allows nulls >>

Entering a NULL value using SSMS

by Scott 1. April 2010 06:58

This happens every once in a while, I need to enter a NULL value when opening a table in SSMS. I'm writing it here so I don't forget what it is.

Highlight the field and press

CTRL + 0 (zero)

09a20fa6-cbac-4886-a8a4-5293c5d98d6a|0|.0

Tags: SQL Server

Related posts

Adding a unique constaint to a column that allows nullsI have an integer column in one of my database tables that allows nulls. What I want is for an...AG_E_PARSER_BAD_PROPERTY_VALUEWhy in Silverlight 3 do I still get these cryptic error messages? This happens quite frequentl...Linq to SQL insert SqlDateTime overflow In my new e-commerce site, I am using Linq to SQL. In all my tables I have modfiedOn and cre...

Add comment

Name*
E-mail* (Will show your Gravatar icon)
Website
Country Country flag

b i u quote

Comment
Preview

Notify me when new comments are added

Twitter

September 6. 14:13
I'm at Romeo Peach Festival (lions fiell, washington and main, Romeo) w/ 13 others. http://4sq.com/dwGZ0G

September 4. 18:53
I'm at Shield's Pizza (7001 N Main St, Rochester Hills). http://4sq.com/9Cju5y

August 28. 13:55
I'm at Michigan Renaissance Festival (12600 Dixie Hwy, Holly) w/ 8 others. http://4sq.com/dclp7A

August 26. 20:30
I'm at Paint Creek Trail at Dutton. http://4sq.com/crnhCV

August 21. 19:29
I'm at Gus O'Connors Irish Pub (324 Main St, Rochester). http://4sq.com/7PTdLr

Follow me

RecentComments

ASP.NET 4.0 URL routing 404 problems with IIS7 (3)
Gilad wrote: saved my day! this post shuld be on the front pag... [More]
ASP.NET 4.0 URL routing 404 problems with IIS7 (3)
Scott wrote: Great to hear :) [More]
Subversion and TortoiseSVN tips and tricks (2)
Scott wrote: I didn't plagiarize anything. I found it useful a... [More]
ASP.NET 4.0 URL routing 404 problems with IIS7 (3)
Eric wrote: This saved me a ton of time - thank you. [More]
Subversion and TortoiseSVN tips and tricks (2)
Mark wrote: Is this plagiarized from here?: http://vidmar.ne... [More]
Product cross sells using Linq to SQL (1)
phone answering service wrote: This is useful and it works. I'm creating a new e-... [More]
Where is Bookpool.com? (2)
David Ball wrote: I also just found out about the BookPool. I doubt ... [More]
Subversion Hosting (3)
ProjectHut wrote: Gotta agree with you - SVN and Trac is a pretty un... [More]