update <table> set <col> = <value> where round(<col>

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

Question Posted / bala

Answer Posted / bala

update <table> set <col> = <value> where round(<col>/10,0)
= (<col>/10)

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we store videos inside the sql server table?

972

Why are you getting errors when creating a new odbc dsn?

1213

Can a database be shrunk to 0 bytes, if not, why?

1090

How to delete existing rows in a table?

1149

What is user-defined multi-statement table-valued function?

1051

How to change the name of a database user?

953

What are synonyms?

955

Do you have any idea about the tcl commands?

956

What is a recursive stored procedure in sql server?

1165

Explain index in sql server?

1009

What is an expensive query?

922

What is the default port for SQL Server over a firewall?

1085

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

Explain nested trigger in sql?

1063

how to trace the traffic hitting a sql server? : Sql server database administration

1864