Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

--Q3: Create a VIEW which includes all the ET-passed trainees.

Create a BizTalk project, and generate schema for the table-valued function you want to invoke in SQL Server. Create messages in the BizTalk project for sending and receiving messages from SQL Server.