How would you Update the rows which are divisible by 10,
given a set of numbers in column?
- 3 Answers
- 10325 Views
- I also Faced
- E-Mail Answers
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 de-normalization and what are some of the examples of it?
how can u get last observation in an unknown dataset ?
What is primary key, unique key, and foreign key?
Define indexes?
What do you know about normalization and de- normalization?
How do you drop an index?
What is a data collection table?
What is plan freezing?
Is natural join and equi join same?
How can we improve performance by using SQL Server profiler?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is 'Join' and explain its various types.
How to create user defined functions with parameters?
What is difference between delete and truncate commands?
Can you move the resources after pausing the node? : sql server database administration
