{{theTime}}

Search This Blog

Total Pageviews

java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint xxxxx

Quick Fix:

Delete the referred record in child table.  Or implement Cascade delete feature.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...