Activity › Forums › Salesforce® Discussions › What is the difference between insert() and database.insert() in Salesforce?

Tagged: , , , , , ,

  • Kumar

    Member
    December 9, 2016 at 6:54 am

    Hi Sushant,

    Unlike DML statements, Database methods have an optional allOrNone parameter that allows you to specify whether the operation should partially succeed. When this parameter is set to false, if errors occur on a partial set of records, the successful records will be committed and errors will be returned for the failed records. Also, no exceptions are thrown with the partial success option.

    For more information, go to

    https://trailhead.salesforce.com/force_com_dev_beginner/apex_database/apex_database_dml

    Hope this helps.

    • This reply was modified 8 years ago by  Kumar.

  • sushant

    Member
    December 12, 2016 at 2:24 pm

    Thanks Kumar

  • shariq

    Member
    July 31, 2017 at 6:29 am

    Hi Sushant,

    You can refer to this link.

    Hope this helps.

  • Piyush

    Member
    August 19, 2019 at 6:05 am

    Insert:

    • A partial insert is not supported.
    • Rollback is not supported.
    • If we use the DML statement (Insert) in bulk operation, then if an error occurs the execution will stop. In that case, Apex code throws an error and none of the records will insert to the database.

    Database.Insert:

    • Database methods are static methods available in Database class.
    • A partial insert is supported.
    • Rollback is supported.
    • Includes the optional all-or-none parameters that default true.
    • If we use DML database methods (Database.Insert) in bulk operation, then if an error occurs the remaining records will be inserted/updated means partial DML operation will be done. The only record throwing an error will not be inserted/updated.

Log In to reply.

Popular Salesforce Blogs

Report

Harassment or bullying behavior
Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Mobile App Reported Contents
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .