null value for all rows of a column!

Is there any way for setting all the rows of a column to a null value?开发者_如何学C thanks

How about something simple like : Update MyTable Set MyColumn = NULL

Or, did you mean you wanted to set all columns in a row to NULL? If so, you have a database design problem. You should greatly limit what columns in a database accept NULL values.

Sure.

UPDATE table SET column = NULL

If you don't include a WHERE clause, the statement will affect all the rows in the table.