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
- 11320 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
Explain full-text query in sql server?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Explain insert into select statement?
Who is the owner of a schema in ms sql server?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How to transfer a table from one schema to another?
What type of Index will get created after executing the above statement?
What is the difference between commit and rollback?
What are the different sql server versions?
Which sql server is best?
Why transaction is important?
List the different normalization forms?
explain different types of cursors? : Sql server database administration
ow to bring suspect mode datbase online from scratch
