how to clear database SQL server 2005

Loeurt

I'm a new learner..Please our member tell me how to write script to Clear data in a specific column ?
Example In table TblStudent(ID, Name, Sex,Address)...
I want to Clean all record in column address..Please help me..
( I Use Sqlserver 2005 databae and C# 2005 application)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Albertto Lie17y ago
Accepted answer
maybe this help..
update TblStudent set address = null
this will hit all record because no criteria given.
Loeurt17y ago
thank you so much..
Subramanyam Rompicherla17y ago
Hi, below script will be helpful for this problem use the Update command for clean a particular column data. "Update your-tablename set delete-column = null;" if you have any issues please let me know