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

Does the order of columns in update statements matter?

Question Posted / nitin yadav


Does the order of columns in update statements matter?..

Answer / Anuj Jaiswal

"No, the order of columns in an UPDATE statement does not matter because SQL Server matches the values to update based on the column names, not their position."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is sub query and its properties?

1 Answers  

What is collation sensitivity?

1 Answers  

what are triggers? : Sql server database administration

1 Answers  

How self join is different from outer join?

1 Answers   Blue Star,

What is difference between clustered and non clustered index?

1 Answers  

What are functions in the sql server?

1 Answers  

In what version of sql server were synonyms released?

1 Answers  

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

how to know description of a table in sqlserver 2000

8 Answers  

What does <> symbol mean?

1 Answers  

What is a cursor in SQL Server 2000 and their types?

8 Answers  

How to fetch the next row from a cursor with a "fetch" statement?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories