Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.
- 8 Answers
- 32522 Views
- Intelenet, I also Faced
- E-Mail Answers
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
Does sql server 2016 have ssms?
How you trouble shoot when any job fails
what are the three command line utilities and what are their primary functions?
What are different types of raid configurations? : SQL Server Architecture
Why use view instead of a table?
What is a subquery in a select query statement in ms sql server?
What is the command dbcc checkdb used for?
Mention the different authentication modes in sql server.
What are the dmvs? : sql server database administration
What are the indexes in sql server?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
In which tcp/ip port does sql server run? Can it be changed?
What is meant by datasource?
What is the language structure to add a record to a table?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
