SBX - Search With Button

SBX - Forum Post Title

Update Employee Payroll dynamically from SQL

Microsoft Dynamics SL Forum

somebody asked a question on 10 May 2019 3:10 PM

Question Status

Suggested Answer

Can you update Employee Payroll dynamically from SQL?

Reply
Carolyn Froton responded on 16 May 2019 7:20 PM
My Badges
Suggested Answer

Hello Somebody,

It depends on what you are doing, You would need the proper permissions on the sql level.  But you can update the database via sql , a trigger is a common thing, if for instance you need the userxxxx field updated with some

internal information as the batch releases, or saves. Many 3rd party applications run triggers to update their own tables as well as ours as another example.

Best Regards,

Jana MacDonald

Reply
Carolyn Froton responded on 16 May 2019 7:20 PM
My Badges
Suggested Answer

Hello Somebody,

It depends on what you are doing, You would need the proper permissions on the sql level.  But you can update the database via sql , a trigger is a common thing, if for instance you need the userxxxx field updated with some

internal information as the batch releases, or saves. Many 3rd party applications run triggers to update their own tables as well as ours as another example.

Best Regards,

Jana MacDonald

Reply

SBX - Two Col Forum

SBX - Migrated JS