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

Explain the truncate command?

918

Can we insert data into view sql server?

883

what type of index will get created after executing the above statement? : Sql server database administration

920

How to convert binary strings into integers in ms sql server?

962

What is the New in SQL server 2008?

917

What is the maximum size per database for sql server express?

973

What are unicode character string data types in ms sql server?

1142

How to backup SQL Server Reporting Services ?

137

What is sql azure database?

205

Tell me the difference between clustered and non-clustered index?

882

Difference between uniqe index and uniqe constraint?

916

What is co-related sub query?

975

What is database replication?

1077

What is amo? : sql server analysis services, ssas

1044

How to configure and test odbc dsn settings?

1097