What happens if you insert a duplicate key for the primary key column in ms sql

What happens if you insert a duplicate key for the primary key column 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

hi i gone though satyam interview. what is Acid Properties?

What are the factors you will check for the performane optimization for a database query?

What is transaction ? Give me one example.

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

If any stored procedure is encrypted, then can we see its definition in activity monitor?

how to generate XML out of QUERY?

How to grant a permission in ms sql server using "grant execute" statements?

How do we rollback the table data in SQL Server

How to assign null values to variables or columns?

How important do you consider cursors or while loops for a transactional database?

How do you load large data to the SQL server database?

For more SQL Server Interview Questions Click Here