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
How do you send email on SQL Server?
What is an execution plan? When would you use it?
what is the maximum size of a row? : Sql server database administration
How to skip remaining statements in a loop block using continue statements?
What is the stuff and how does it differ from the replace function?
How to create new tables with "select ... Into" statements in ms sql server?
What is a heap?
What is the maximum size of sql server database?
What do you think of this implementation? Can this be implemented better?
How to apply filtering criteria at group level with the having clause in ms sql server?
What programming language would you use to create embedded functions in ssrs?
What are the requirements to use odbc connections in php scripts?
What are “unrepeatable reads”?
What happens when transaction log is full?
How do you troubleshoot errors in a SQL Server Agent Job?