How to update multiple rows with one update statement in ms sql server?

Question Posted / sanjeev saxena

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

Do you know how to make remote connection in database?

Can I remove the default constraint columns in SQL SERVER?

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

What are various aggregate functions that are available?

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

If there is failure during updation of certain rows, what will be the state?

How global temporary tables are represented and its scope?

What is tempdb in sql server?

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

is there a column to which a default can't be bound? : Sql server database administration

For more SQL Server Interview Questions Click Here