Monday, January 21, 2008

Setting a column value to NULL in SQL Server Management Studio

If you've opened a table in SSMS, and you want to clear an existing value to NULL, click on the value, and press Ctrl+0 (zero).

Sam said...: Wow, very useful, thanks.; January 21, 2008 1:09 PM
fartiblartsmart said...: Not such a discovery though, the client tools did this all the way back to SQL Server 7.0 (and probably before....); January 22, 2008 11:18 AM
Simon said...: You know that, I know that, but not everybody knows that, which is why I posted. There are people who never used the old tools, and are new to SQL Server, and maybe others who have used the tools for years but didn't know that shortcut existed.

Just because it isn't new, doesn't mean it isn't worth posting.; January 22, 2008 11:22 AM
Ken said...: Simon, thanks for posting this. You saved me a bunch of time.; April 04, 2008 5:01 PM

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Search