Learn How to Do-It-Yourself!

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.

This image shows a field in the column named 'Content', just before being made NULL using CRTL-0.

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.


_______________________________________
Save this  Email this  |  Digg this!  |  del.icio.us  |  RSS 

Related Articles


Add your comment

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

Title:  

Comment:  
Join now for free to keep track of all your comments and have them appear instantly.

Sponsored Links

Search for keywords: