Thanks but I would like to display the rows in error when the error occurs - it could also be a foreignKey that needs to be inserted or a column that can't be null etc. So what I would like is to just return the values that caused the error - if this is possible.
The source is a db table, yes....
ringdrossel
Last Activity: Nov 17 '08, 10:17 AM
Joined: Sep 19 '08
Location:
-
Get Row(s) in error MSSQL2005
Hi, I have a allready a try catch block around my sql execution (T-SQL) code.
1) Now in case of an error the server writes something like "could not insert duplicate key..." etc. Now it would be a tremendous help to know which row gave the error i.e. by returning the ID or the data of the columns in question.
2) Think this will probably not work but ... furthermore is there a way to get all...
No activity results to display
Leave a comment: