select * from TableName where ColumnName%10=0

How would you Update the rows which are divisible by 10,
given a set of numbers in column?

Question Posted / picture12345

Answer Posted / picture12345

Is This Answer Correct ?

7 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What does ss stand for sexually?

1143

How to rename databases in ms sql server?

1259

How to call stored procedure using http soap?

1130

Can you tell me some of the common replication dmv's and their use? : sql server replication

975

How to find related tables in sql server?

1001

What are the common performance issues in sql server?

972

How does a profiler work?

994

How to verify a user name with sqlcmd tool?

1120

Tell me the phases a transaction has to undergo?

1019

What are different types of statement?

1085

Can we take the full database backup in log shipping?

995

Explain few of the new features of sql server 2008 management studio

978

What is create statement?

1008

Explain magic tables in sql server?

1103

What are the system database in sql server 2008?

1096