SQL Server Exception Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In SQL Server, if an attempt is made to input to the database a record with
an id number that already exists, what exception is generated?

Thanks,
Fred
 
All exceptions thrown by the DB will be SqlExceptions - the message will be
something like System.Data.SqlClient.SqlException: Violation of PRIMARY KEY
constraint 'Key_Name'. Cannot insert duplicate key in _____
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
SQL Sever connection denied after computer restarted 2
An error has occurred while establishing a connection to the server.When connecting to SQL Server 20 0
Am I disturbing a machine in production floor if I access its database remotely? 4
continue execution after try/catch 3
I need help on SQL 0
SQL Server connection issue 4
Throw Exception and using Dispose? 1

Back
Top