Weakly type vs strongly type stored procedures in Biztalk
The difference between Weakly Type vs strongly type Stored procedures in Biztalk is the way schema is generated. For a procedure under the Procedure node in Biztalk, the schema is weakly typed. However, for a procedure under the Strongly-Typed Procedure node, the schema is strongly typed.
Strongly-typed schema is useful if you want to map schema of one operation to another operation using BizTalk mapper because the schema is available to you in design-time while creating the BizTalk project. For weakly-typed procedures, the schema for the procedure is received at run time as part of the response message.
To learn more visit the following article at msdn: http://msdn.microsoft.com/en-us/library/dd788445(v=BTS.70).aspx
The following figures shows the difference between the schemas generated when picking weakly type vs strongly type stored produces