how to clear database SQL server 2005
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)
Answers (3)
0
maybe this help..
update TblStudent set address = null
|
this will hit all record because no criteria given.
0 thank you so much..
0 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