AX / Dynamics 365 For Finance and Operations blog

SQL SERVER – Update top n records in sql server

This code willupdate first 100 rows of your table

update top (100) table1 set field1 = 1

More Posts

19.03

How to Increase the Number of Decimal Places in a Numeric Field in a Form (Dynamics 365 / AX)
16.12

How to Join Multiple Data Sources on Multiple Fields in a D365FO Form Query
24.10

SQL Azure DB – Creating a Restricted User in Azure SQL Who Owns Only Their Schema
23.10

AX / D365FO – Converting Enums to Text in SQL Views: The X++ Way
29.08

AX / D365FO – How to Call One Form from Another in Dynamics 365 Finance & Operations
11.06

AX / D365FO – Handling Time Zone Offsets and Daylight Saving in D365FO with X++

Leave a Reply Cancel reply