1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / pandian s

UPDATE TableName SET Column1 = <Value>
WHERE ColumnName % 10 = 0

Is This Answer Correct ?    8 Yes 2 No

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

Answer / bala

update <table> set <col> = <value> where round(<col>/10,0)
= (<col>/10)

Is This Answer Correct ?    5 Yes 0 No

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

Answer / picture12345

select * from TableName where ColumnName%10=0

Is This Answer Correct ?    7 Yes 10 No

Post New Answer

More SQL Server Interview Questions

what is the difference between group and having give an example with query and sample output

7 Answers  

What is an extended Stored Procedure?

1 Answers  

Explain what is it unwise to create wide clustered index keys?

0 Answers  

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

0 Answers   TCL, Wipro,

What is the difference between having clause and where clause in sql server?

0 Answers  




how can ur insert the emp table

3 Answers   Wipro,

What are the dmvs? : sql server database administration

0 Answers  

How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

Explain transaction server implicit?

0 Answers  

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

Explain Trigger with an example?

2 Answers  

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories