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

select * from TableName where ColumnName%10=0

Is This Answer Correct ?    7 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what is a with(nolock)?

1060


What are the different subsets of sql?

1552


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

973


How to recover from sql injection? : sql server security

1023


Explain the difference between primary keys and foreign keys?

1034


What is trigger and different types of Triggers?

1149


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2788


Explain primary key and foreign key constraints?

1035


How many types of triggers are there?

1068


How do I start and stop sql server?

1027


What is a print index?

887


What stored procedure would you use to view lock information?

978


What are the dmvs?

1015


What is the purpose of sql profiler in sql server?

1023


What is difference between getdate and sysdatetime in sql server 2008?

1054