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

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++
29.04

AX / D365FO – Preventing Auto-Creation of Empty Child Records in D365FO Join Forms with Chain of Command

Leave a comment Cancel reply