Interested to Buy Any Domain ? << Click Here >> for more details...
How would you Update the rows which are divisible by 10,
given a set of numbers in column?
- 3 Answers
- 11627 Views
- I also Faced
- E-Mail Answers
Answer Posted / bala
update <table> set <col> = <value> where round(<col>/10,0)
= (<col>/10)
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
When cursors are useful?
What are the disadvantages of using querystrings to send data from one page to another?
What is the difference between getdate and sysdatetime?
How to select some specific rows from a table in ms sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
What are the properties of the transaction?
How to write a query with a left outer join in ms sql server?
Can an entity have two primary keys?
How to list all user names in a database?
Explain syntax for viewing trigger?
What are statistics?
How to download microsoft sql server 2005 express edition?
can we have a nested transaction? : Sql server database administration
How to rename an existing column with sql server management studio?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
