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
- 11485 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
What is a non-clustered index?
What command is used to rename the database?
How do I shrink an ldf file?
Write the syntax for stuff function in an sql server?
What are “phantom rows”?
What is TDS(Tabular Data Stream) Gateway?
What is transaction server consistency?
how will add additional conditions in sql?
How many levels of sp nesting is possible?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is user defined datatypes and when you should go for them?
What is the difference between an index and a unique index?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What are the difference between primary keys and foreign keys?
Why we should not use triggers?
