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
Do you know what is a with(nolock)?
What are the different subsets of sql?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to recover from sql injection? : sql server security
Explain the difference between primary keys and foreign keys?
What is trigger and different types of Triggers?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Explain primary key and foreign key constraints?
How many types of triggers are there?
How do I start and stop sql server?
What is a print index?
What stored procedure would you use to view lock information?
What are the dmvs?
What is the purpose of sql profiler in sql server?
What is difference between getdate and sysdatetime in sql server 2008?