Respecto a schema json
The example above shows how to validate the request body in the update. This is the simplest of the functions for JSON support in SQL Server. The message target can also be set outside of the assertion properties. In this example I copied the id schema from earlier in the document. For example, email, and date.