Start Sql updating

Sql updating

In our case it says to update the Email filed of the row having email [email protected]

To do that, use the following SQL statement: In both UPDATE example having WHERE clause above, I've changed a table field to new value, using the same field in the WHERE clause criteria.

This was purely coincidental and you can update different field(s) than the one used in your WHERE criteria, for example: When updating make sure that the WHERE clause criteria you have specified updates only the rows you want.

To add a new document type to the Dynamics GP Service platform, you need to add SQL stored procedures that create, and update documents in the Dynamics GP database.