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
Explain about temporary stored procedure?
What is the server name for sql management studio?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What is user-defined function?
How many categories of data types used by sql server?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Explain about service Broker functions?
When columns are added to existing tables, what do they initially contain?
What are sparse columns?
Is the order of columns in the set clause important in ms sql server?
What is the cpu pressure?
How to find the service pack installed? : sql server database administration
What are the 10 characteristics of data quality?
What is the function of sql server agent windows service?
Explain database normalization?