Home Forums SQL Server 2008 T-SQL (SS2K8) Finding row number which caused the error in Table value parameter insertion RE: Finding row number which caused the error in Table value parameter insertion
schleep
SSChampion
Points: 12582
More actions
September 5, 2013 at 5:17 am
#1647655
In your stored proc, why not simply check for rows which will cause an error (datalength > 2, in this case) , select them and return a message to the client?