Executing a stored procedure that takes a single parameter is similar to executing any other stored procedure as described in Execute Stored Procedures in SQL Server using BizTalk Server.However, for ...

execute statement 'insert into clients (pcode, fullname) values (:pcode, :fullname)' (execute statement 'select pcode, fullname from clients' on external :db) It will be very usefull for cross ...

EXECUTE usp_InsertBigScreenProducts @TableVariable = @DataTable. ... Despite these minor drawbacks, I definitely recommend exploring the table parameter feature when SQL Server 2008 comes out.