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

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

Question Posted / pandian s

Answer Posted / pandian s

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

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between varchar and varchar types?

1058

How to provide values to stored procedure parameters in ms sql server?

1010

What are .mdf files?

922

What is the maximum size of a row in sql server?

951

How to configure and test odbc dsn settings?

1139

How to use clusters?

921

What is table level trigger?

995

How to count rows with the count(*) function in ms sql server?

993

What is bulkcopy in sql?

934

Explain what is “asynchronous” communication in sql server service broker?

896

How to find out what is the default collation in a database?

1105

How to generate create table script on an existing table in ms sql server?

1132

Do you know what are the properties of the relational tables?

1013

What you can do to delete a table without the delete trigger firing?

952

What do you understand by check constraint in sql server?

929