Set Field to Null in Sql Server Enterprise Manager Result Set

Have you ever edited a result set in Enterprise Manager and wished that there was a way to set a field to null? Your in luck because there is a way.

If you are in the field you want to set null you just hit CTRL-0 and leave the field and magically the field has a null value, of course you can only do this on fields that are actually nullable.

Maybe I'm the only person that didn't know about this but I posted this just incase someone else can benefit from this.

Published Sunday, October 19, 2003 10:48 AM by puzzlehacker

Comments

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

cool! i never heard about!

Monday, October 20, 2003 1:18 PM by v.nrg

# Nice EM tip

Monday, October 20, 2003 1:34 PM by TrackBack

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

I've never heard about it. But could you explain further to me what you meant?
Thanks Wes.
Great tips!
Blog Rocks!!!

Friday, October 31, 2003 8:07 AM by Ahmat

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

GREAT THANKS A LOT

Friday, January 16, 2004 10:31 AM by Julio Cesar De Salvo

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

What about programmatically changing a numerical field from a number back to NULL?

Thursday, April 08, 2004 3:29 PM by Bill

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

I know how to do it in .Net. If you are using a dataset just set the value to DBNull.Value. I think that exists in the System.Data.SqlTypes namespace.

Thursday, April 08, 2004 3:32 PM by Wes

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

How to enter a empty string in EM? If the field is NULL-able, and has not other default value, then the default is NULL. But how to get an empty string ('') there?

Thursday, April 15, 2004 7:35 PM by W

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

What I have done before is enter some text then leave the row, then go back and delete the text. It will leave the empty string instead of null.

Thursday, April 15, 2004 7:53 PM by Wes

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

That seems pretty good. I hope there's also a ctrl-something that would enter empty string directly.

Friday, April 16, 2004 12:16 PM by W

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

How about making a whole column null is that possible like

update table
set column_name = NULL
??

Thursday, May 13, 2004 12:24 AM by R

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

so cool

Thursday, June 10, 2004 11:58 AM by an

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

In Enterprise Manager, after showing the grid pane and changing the query type to UPDATE, enter Null in the New Value field. You can also use a query in Query Analyser like the one posted by R.

Wednesday, September 06, 2006 1:32 AM by luke

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

Useful to edit fields directly, but how to do the same thing using grid and drop down combo components? On Sheridan data widgets there is no way to translate null values to the field, someone know something ablut this? THANKS!!!

Thursday, November 23, 2006 1:14 PM by Al Varo

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

Guys it much easier than expected, Simply press CTRL + 0

Sunday, December 10, 2006 7:59 AM by Dwaik

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

I have been looking for this for so long. Thanks.

Wednesday, March 28, 2007 11:37 AM by Longmatch

# re: Set Field to Null in Sql Server Enterprise Manager Result Set

Thanks for posting this.. VERY Helpful..

Wednesday, January 23, 2008 12:15 PM by esank

Leave a Comment

(required) 
(required) 
(optional)
(required)