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
- 33098 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
How do you clear a log file?
What is the difference between a local and a global temporary table?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is the name of the Database which IBM mainframe uses?
How to delete existing rows in a table?
Where do we use trace frag?
What is the return type of executeupdate ()?
What do you think of this implementation? Can this be implemented better?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is difference between line feed ( ) and carriage return ( )?
What is the default fill factor value?
What is similarity and difference between truncate and delete in sql?
In what three ways is the return statement used in a stored procedure?
Does partitioning ssd reduce performance?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
