Microsoft BizTalk Adapter for SQL Server (64 bit)

Microsoft BizTalk Adapter for SQL Server features insert, update, delete, and select operations on tables and views, invoke (SQL and CLR) stored procedures, scalar valued functions, and table value functions, supports execution of generic T-SQL statements, via the ExecuteReader(), ExecuteNonQuery(), and ExecuteScalar() operations, support for x86 and x64 platforms, support for new data types in SQL2005 and SQL2008 (notably FILESTREAM, varbinary (max)), ability to pass table value parameters, composite operations - invoke operations on multiple tables and call any number of stored procedures in the same transaction, and ability to directly call stored procedures which used the 'for xml' style supported by the BizTalk 2006 SQL adapter to ease backward compatibility.