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.
by Updated January 29, 2009

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.



Add your comment

by Anonymous - Already have an account? Login now!
Your Name:  

Enter the text you see in the image below
What do you see?
Can't read the image? View a new one.
Your comment will appear after being approved.

Related Posts

If you’ve experienced as many problems as I have while trying to Import/Export my Sql Server 2005 database to a hosting provider for the first time, then hopefully this how-to will be of some assistance to you.  more »

This step-by-step goes through the process of importing delimited text files into a SQL Server 2005 database. The example should help you better understand how to import different types of flat files into SQL Server 2005.  more »

Here's one way to setup your connection string for a SQL Server 2008 Express database for a live website using ASP.NET on Windows Server 2008. Open "Sql Server Configuration Manager" -> the click on "SQL Server Network Configuration" -> then click...  more »

This tutorial goes through the steps of how to import a SQL script file into a MySQL database.  more »