Using SQL Adapter "Function in Store procedure" Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Using SQL Adapter "Function in Store procedure" This topic has 1 reply, 1 voice, and was last updated 9 years, 1 month ago by community-content. Viewing 1 reply thread Author Posts February 12, 2008 at 7:30 AM #18913 community-content Hi all I try auto generating Schema to be used for Sql UpdateDatagram The problem I am facing is that I have a column, whose value is supplied by a built in Function, called inside the StoreProcedure. How do I specify or generate the Schema. Knowing that the coulmn value is defined in an insert statement , but not in Declaration in Insert varaibles. Regards Ed February 12, 2008 at 9:18 AM #18916 community-content Not sure if this will work for you situation, but can’t you wrap your SQL call in a stored proc and return data from it.. Author Posts Viewing 1 reply thread The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies. Log in / Register