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

Difference between group by clause and having clause in SQL?

Can you explain the disadvantages/limitation of the cursor?

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

What is a covered index?

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

How to see existing views in ms sql server?

What is the difference between char, varchar and nvarchar?

How self join is different from outer join?

Can you explain the types of Joins that we can have with Sql Server?

What are the results of running this script?

Why normalization is used?

How do I find the transaction log size in sql server?

For more SQL Server Interview Questions Click Here