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
- 11426 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 “@@rowcount” and “@@error” in sql server?
What are character string data types in ms sql server?
Why and when do stored procedure recompile?
What is field with example?
What is the difference between dataadapter and datareader?
Is truncate a dml command?
Where actually sql azure database is hosted?
Do you know hot add cpu in sql server 2008?
How to end a stored procedure properly in ms sql server?
What are the different types of collation sensitivity in sql server?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is the difference between upgrade and migration in sql server?
Is ssrs support other database except ms sql server?
Mention the 3 ways to get a count of the number of records in a table.
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
