One of the coolest parts of the x++ language is using a select statements A select statement allows developers to fetch and manipulate data from a database. The data is loaded into table variables. Finally, these table variables can have methods where code be added to work with the data.
#Dynamics365 #Dynamics365Musings #MSDyn365 #MSDyn365Community #DYN365O #D365FO #Microsoft #d365ug #xppgroupies #D365 #SelectStatement #TableBuffer
https://dynamics365musings.com/select...

Subscribe to my channel:
   / @peterramer  

Related Blog: https://dynamics365musings.com
LinkedIn:   / peter-ramer  
Twitter:   / peter_ramer  

Table of Contents:

00:00 - Intro
00:08 - X++ Select Statement
01:33 - Example Select Statement
02:14 - Define Table Buffer Variable
03:50 - Basic Select Statement
05:50 - Using A Table Buffer
08:24 - Where Clause
09:41 - Field List
10:47 - When To Use A Field List
11:30 - Select All Fields
12:28 - Differences From Transaction-SQL
13:43 - FirstOnly Keyword
15:38 - Select Vs While Select
16:02 - Summary
16:42 - Outro