Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL INSERT FAIL

Options
  • 04-04-2013 9:09pm
    #1
    Not Easy
    Closed Accounts Posts: 46 ✭


    To demonstrate the use of rollback/save point, we are to deliberately create a failing insert..

    What is a failing insert? I was thinking it may mean incorrect Syntax but I`m thinking there is more to this than that?

    Thanks


Comments

  • Options
    #2
    PaulKK
    Registered Users Posts: 2,279 ✭✭✭PaulKK


    Not Easy wrote: »
    To demonstrate the use of rollback/save point, we are to deliberately create a failing insert..

    What is a failing insert? I was thinking it may mean incorrect Syntax but I`m thinking there is more to this than that?

    Thanks

    Could just try insert a duplicate key, the insert will fail and you can roll back the transaction.


  • Options
    #3
    CreepingDeath
    Closed Accounts Posts: 8,015 ✭✭✭CreepingDeath


    Duplicate primary key would be the most straightforward..

    others include ( on insert )

    null column when the column has a not null constraint and no default,
    non existent foreign key constraint,
    duplicate column on a unique indexed column


  • Options
    #4
    croo
    Moderators, Technology & Internet Moderators Posts: 1,334 Mod ✭✭✭✭croo


    ... or basically anything that breaks a constraint rule!


  • Options
    #5
    DublinWriter
    Registered Users Posts: 9,557 ✭✭✭DublinWriter


    ...or trying to insert 40 characters into a 20 character string field, etc.


Advertisement