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

Tell me about normalization in DBMS.

583


What is the difference between cartesian product and cross join?

482


I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

607


How can I create a new template for import ? : sql server management studio

603


How to find index size for each index on table?

587






How to create a testing table with test data in ms sql server?

562


when you create a database how is it stored? : Sql server database administration

499


What is sharding?

88


How to delete database objects with "drop" statements in ms sql server?

598


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

592


What does the on delete cascade option do?

558


System variable and temporary variables

1716


Can a table be created inside a trigger?

568


How display code or Text of Stored Procedure using Sql query in Sql Server ?

613


Explain different backup plans?

534