How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.
Answer Posted / rupa bagherwal
You can not exactly delete the column value.
alternatively what you can do is use update statment and
update the value with blank.
update users
set user_adr = ''
where user_id = 'userid'
| Is This Answer Correct ? | 96 Yes | 12 No |
Post New Answer View All Answers
What is difference between cte and view?
Tell me when is the update_statistics command used?
How to find the service pack installed? : sql server database administration
Define constraints and give an example of their use?
What is row_number function?
Explain different forms of normalization?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is nolock?
What’s the use of custom fields in report?
How to stop log file growing too big?
What stored by the model? : sql server database administration
What do you understand by replication in sql server?
What is mapping schema?
What is correlated subquery in sql server?
How can I create a report based on a query? : sql server management studio