How to Set a Field to Null In a Sql Server 2005 Result Set
Quickly set a field to null in a Sql Server database result set.
Wednesday, March 8, 2006
If you ever wanted to change a field to null in a Sql Server 2005 Management Studio result set, you're in luck because there is a quick and easy way to do it.
In order to set a field to null, put your mouse cursor in the field that you would like null and hit CTRL-0. Now the field will have changed and you should now see null. This works as long as the field accepts null values.
You may also use CTRL-0 in Sql Server 2000 Enterprise Manager to change fields to null.