How would you Update the rows which are divisible by 10,
given a set of numbers in column?
Answer Posted / pandian s
UPDATE TableName SET Column1 = <Value>
WHERE ColumnName % 10 = 0
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is GUID in sql server?
What is the difference between for trigger and after trigger?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What is the use of keyword with encryption. Create a store procedure with encryption?
Where do you find the default Index fill factor and how to change it?
How to access the deleted record of an event?
How to use “drop” keyword in sql server and give an example?
what is isolation level at dead lock?
application server is slow what may be the problem
What do you mean by stored techniques? How would we use it?
explain different levels of normalization? : Sql server database administration
Explain different types of Normalization.
You want to use a perspective in an mdx query. How do you select the perspective?
What are the security related catalog views? : sql server security
How to create prepared statements using odbc_prepare()?