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 data modeling and Reterminal integrity?

1955

Define tempdb database?

997

Can we check locks in database? If so, how can we do this lock check?

944

what are the new features in SSRS?

134

Explain logical operators in sql server?

1108

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1049

What happens when the SQL Azure database reaches Max Size?

111

Do you know how to implement service broker?

928

List some advantages and disadvantages of stored procedure?

1016

How to execute function in stored procedure sql server?

1154

What's new in sql management studio for sql server? : sql server management studio

1065

What are group functions in query statements in ms sql server?

1010

Does full backup break log chain?

962

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1077

What are the differences between stored procedure and view in sql server?

1248