使用SQL Server给Dynamics 365实体插入数据

发布时间 2023-05-08 16:56:33作者: 溜溜球_小钢

 

INSERT INTO [dbo].[new_PublicDictionaryBase]
           ([new_PublicDictionaryId]
           ,CreatedOn
           ,[CreatedBy]
           ,ModifiedOn
           ,[ModifiedBy]
           ,[OwnerId]
           ,[OwnerIdType]
           ,[OwningBusinessUnit]
           ,[statecode]
           ,[statuscode]
           ,[new_name]
           ,[new_type])
     VALUES
           (NEWID()
           ,GETDATE()
           ,'2990FC1A-60AC-EA11-8AC0-000C29BED1D3'
           ,GETDATE()
           ,'2990FC1A-60AC-EA11-8AC0-000C29BED1D3'
           ,'2990FC1A-60AC-EA11-8AC0-000C29BED1D3'
           ,8
           ,'158EFC8C-C6AB-EA11-8ABD-000C29BED1D3'
           ,0
           ,1
           ,'1111'
           ,'22222')