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 would you Update the rows which are divisible by 10,
given a set of numbers in column?

Answer Posted / pandian s

UPDATE TableName SET Column1 = <Value>
WHERE ColumnName % 10 = 0

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is GUID in sql server?

1092


What is the difference between for trigger and after trigger?

1024


What is the minimum recommended amount of ram for sql server 2012 enterprise?

887


What is the use of keyword with encryption. Create a store procedure with encryption?

900


Where do you find the default Index fill factor and how to change it?

1015


How to access the deleted record of an event?

976


How to use “drop” keyword in sql server and give an example?

1089


what is isolation level at dead lock?

2088


application server is slow what may be the problem

2165


What do you mean by stored techniques? How would we use it?

978


explain different levels of normalization? : Sql server database administration

929


Explain different types of Normalization.

1734


You want to use a perspective in an mdx query. How do you select the perspective?

231


What are the security related catalog views? : sql server security

913


How to create prepared statements using odbc_prepare()?

996