Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.

Question Posted / rupa bagherwal

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


Please Help Members By Posting Answers For Below Questions

What are synonyms?

1016

What is bit data type?

1081

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1184

What is the default fill factor value?

1128

What are indexes in ms sql server?

1117

What are the source of constraints?

979

What are logical/boolean operations in ms sql server?

1103

How to change the ownership of a schema in ms sql server?

1258

What is the difference between Stored Procedures and triggers?

1133

Can we write a distributed query and get some data which is located on other server and oracle database?

1278

What are acid properties of transaction?

995

What is NOT NULL Constraint in sql server 2012?

1047

How to implement service broker?

1072

How to deploy the Report?

140

What happens if we shrink log file in sql server?

1031