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...

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 / nilesh

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

Is This Answer Correct ?    17 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to loop through the result set with @@fetch_status?

1429


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1662


explain extended properties

1036


How do I find sql server instance name?

1006


Explain having clause?

1028


What can be used instead of trigger?

1206


what is a schema in sql server 2005? : Sql server database administration

1081


Can we write trigger for view?

1067


How to write a query with a full outer join in ms sql server?

1156


What is the use of commit?

1057


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2074


How many primary keys are possible in a table?

963


What happens if null values are involved in boolean operations?

1041


You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1144


What is the difference between Normalization and De-normalization?

1141