Let’s say you are viewing results in Enterprise Manager or the SQL Server Management Tools and you really want to update a cell will a NULL value. Sure you could script it. Heck, you’re welcome to wrap the one line script in a Transaction and produce a rollback script as well if you’d like. But, if you are lazy like me, you just want to update the value using tools, all reckless-like. The trick is to select into the cell and press the lucky CTRL + 0 key combo. That’s a zero, by the way. I also go for CTRL + DEL, and then wonder why NULL doesn’t magically appear. Hence the post.
You can also type the word NULL in all capital letters, I use that all the time.
@Eric – Thanks for the comment. You’re right. Typing NULL works in SSMS. I’m pretty sure it didn’t/doesn’t work with SQL Enterprise Manager though.
What other keyboard shortcuts can be used in the table view? Is there one for current date/time?
Have you ever considered about including a little bit more than just your articles? I mean, what you say is important and everything. However think about if you added some great graphics or video clips to give your posts more, “pop”! Your content is excellent but with pics and videos, this blog could definitely be one of the very best in its niche. Very good blog!
Do you have a spam problem on this website; I also am a blogger, and I was wanting to know your situation; many of us have developed some nice procedures and we are looking to swap strategies with others, be sure to shoot me an e-mail if interested.
Si tu cherches du sexe gratis, je t’invite à vite te rendre sur ce site pour hétéros. Chez nous, on propose tous les styles de vidéos pornographiques qu’on peut trouver sur le Web. Viens te faire plaisir sur notre blog de cul ! On a vraiment tout ce que tu pourrais vouloir télécharger. via
I just want to say I’m very new to weblog and absolutely liked you’re blog site. Almost certainly I’m likely to bookmark your website . You certainly have perfect articles and reviews. Kudos for sharing with us your website page.