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 – Team Build Error: The Path … is already mapped to workspace
  • AX / D365FO – COnverts String in Upper case
  • SQL SERVER – Troubleshoot high-CPU-usage issues
  • AX / D365FO – How to do an Inventory recalculation for on-hand Qty
  • AX / D365FO – Clear Work user sessions on Warehouse Mobile app

Categories

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

Join 1,474 other subscribers
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 68 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