Using Sql Code updated to the Dynamics AX 2009 system field values for table (Created datetime)
The following SQL code using updated to the Dynamics AX 2009 Created datetime for SalesTable record
Wrote by Jimmy Jan 21th 2011.
![](https://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif)
declare @dataareaid nvarchar(4)
declare @salesid nvarchar(20)
declare @datetime datetime
/* edit the fields below */
set @dataareaid = 'QCN'
set @salesid = 'QVSC000001US'
set @datetime = '01/01/2011 00:00:00.000'
/* do not edit here */
update DBO.salestable set createddatetime = @datetime
where salesid = @salesid and dataareaid = @dataareaid
update DBO.salesline set createddatetime = @datetime
where salesid = @salesid and dataareaid = @dataareaid