SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 REMOVE NULL FROM A SPECIFIC FIELD OF SQL 2005
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

baijuep
Starting Member

India
12 Posts

Posted - 09/08/2012 :  22:36:49  Show Profile  Reply with Quote
I HAVE A TABLE NAMED ANIL AND A FIELD IN IT I STATUS AND I WANT TO REMOVE NULL FROM THAT FIELD. I DID IT MANUALLY BUT MY DATABASE IS INCREASING AND FACING TROUBLE TO MANUALLY REMOVE IT

baijuep

baijuep
Starting Member

India
12 Posts

Posted - 09/09/2012 :  04:16:21  Show Profile  Reply with Quote
I MYSELF GOT THROUGH

Update TABLENAME set FIELDNAME=' ' where FIELDNAME is null

baijuep
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 09/09/2012 :  12:14:44  Show Profile  Reply with Quote
why not set the logic in population step itself so that you dont have to do this separately each time?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000