Answer / 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'

Answer / subramaniam

Rupa Bagherwal is told the answer is correct
we cant delete particular value in one column
we can update onle

delete from employee where employeeid=2

suppose we wil give like this means it will delete one row

for this questions update only possible

Answer / nilesh

Update tablename set Column_name = '' where f_name = 'student'

Answer / nadeer

we can't delete a particular value of column,
instead of this we can make that column value as
blankspace,or u can rewrite a values on it by "update emp
set id=5555 where id=4444;

Answer / krish

DELETE FROM tablenameWHERE columnname AND columnname

Answer / sunil kumar basuru

we cant delete the particular column because oracle two
dimensional structure.but instead of delete we can do column
'null'

Answer / elumalai.k

delete from tablename where columnname=datatype
examples:
delete from employee where employeeid=2

Answer / suresh.s

Example:
Delete from STUDENTDETAILS where StudentID = 101

What are the different authentication modes in sql server?

0 Answers  

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

Explain Capacity planning to create a database? and how to monitor it?

0 Answers  

What is PROJECTION Operation?

0 Answers   Infosys,

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

What is ACID Property of Transaction?

10 Answers  

What is sub query and its properties?

0 Answers  

How do I perform an unattended install of sql server 2000?

0 Answers  

Explain sp_configure commands, set commands?

3 Answers  

What is the sql case statement used for?

0 Answers  

What is partition in sql server?

0 Answers