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
Tell me about normalization in DBMS.
What is the difference between cartesian product and cross join?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
How can I create a new template for import ? : sql server management studio
How to find index size for each index on table?
How to create a testing table with test data in ms sql server?
when you create a database how is it stored? : Sql server database administration
What is sharding?
How to delete database objects with "drop" statements in ms sql server?
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?
What does the on delete cascade option do?
System variable and temporary variables
Can a table be created inside a trigger?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Explain different backup plans?