Skip to content
  • Contacts
  • Articles
  • Categories

AX / Dynamics 365 For Finance and Operations blog

Category: Delete

Delete all record from table at once for better speed performance (delete_from)

Posted on 20 July 202120 July 2021 by Marco Saad

//declare table varibale MyTable myTable; ttsbegin; // to delete all records with any condition delete_from myTable; or //delete records based on some condition delete_from myTable where mytable.Recid = 12345677; ttscommit;

Leave a comment

Cerca

Recent Posts

  • AX / D365FO – List of all Symbols fonts (Image icons for tiles and buttons)
  • AX / D365FO – Create a Tile in a D365FO Workspace with X++
  • AX / D365FO – Debug Production environment on D365FO On-Premise version
  • sql server – Free disk SPACE USING SHRINK
  • AX / D365FO – Log “only errors” in Batch jobs History

Categories

Enter your e-mail address to subscribe to this blog, and receive notifications of new posts by e-mail.

Join 53 other followers
Follow AX / Dynamics 365 For Finance and Operations blog on WordPress.com
Blog at WordPress.com.
  • Follow Following
    • AX / Dynamics 365 For Finance and Operations blog
    • Join 53 other followers
    • Already have a WordPress.com account? Log in now.
    • AX / Dynamics 365 For Finance and Operations blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar