Updating multiple tables from BizTalk and validating the incoming message in SP

Sometimes, we may have the requirements to insert/update more than one table in SQL server from BizTalk using SQL Adapter as well as we have to validate the passing parameter - message in SP before updating database. This will help us to check the data type as well as data.

We need to follow the following steps

Step 1:
Create xml schema collections in SQL 2005

CREATE XML SCHEMA COLLECTION [dbo].[TableSchema] AS N''

Step 2:
Create the stored procedure as below


CREATE PROCEDURE [dbo].[iu_Table_sp]
@xmlTable AS XML (TableSchema)