How would you Update the rows which are divisible by 10,
given a set of numbers in column?

Answer Posted / picture12345

select * from TableName where ColumnName%10=0

Is This Answer Correct ?    7 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the fillfactor concept in indexes?

545


Give me any three differences between Truncate and Delete.

578


your distribution database is full what will u do

1687


Give me a SQL Query to find out the second largest company?

696


Which is the best place or learning center for MS SQL?????In Bangladesh?????

1600






What is sql server profiler trace data file?

594


Explain the database you used in your final year project?

550


Why use cursor in sql server?

560


What are the different types of locks in the database?

492


What is create statement?

541


on line cluster can we make if yes tell me the procedure

1521


Different types of keys in SQL?

640


Explain the properties of sub-query in sql server?

521


Can you please differentiate between a primary key and a unique key?

546


What causes index fragmentation?

586