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
- 11619 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 are the types of subscriptions in SQL Server replication?
How does recursive cte works in sql server?
Do you know what is sql injection?
What do you mean by stored techniques? How would we use it?
Which joins are sql server default?
What will be query used to get the list of triggers in a database?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Where the sql logs gets stored? : sql server database administration
what's the difference between delete table and truncate table commands? : Sql server database administration
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is difference between delete and truncate commands?
What is tabulation?
What is single-user mode?
What are distributed partitioned views?
What is Sqlpaging in SqlServer 2005 ?
