Sunday, September 09, 2012 2:42 AMI 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
I am a System Administrator at Vadodara
- Changed Type Eileen ZhaoMicrosoft Contingent Staff, Moderator Thursday, September 20, 2012 2:41 AM it's question
Sunday, September 09, 2012 3:19 AMCan you explain how you remove the NULL manually? Do you use a query? If yes, then please post your query.
Tuesday, September 25, 2012 1:30 AMModeratorHi Baiju EP,
It seems that you want to update the Status with other values, if in this case, you can using T-SQL like below:
Update ANIL Set STATUS ='the vaule you needed' Where STATUS Is Null
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Tuesday, October 02, 2012 7:13 AM