Microsoft® SQL Server 2008 R2 Unleashed

Building Web Services

Let’s delve right into the process of building a web service in SQL Server 2008.

The first step is to decide which data or T-SQL functionality to expose to the clients who will ultimately call the web methods.

For this first example, you should create the stored procedure shown in Listing 48.1, which returns a row of data from the AdventureWorks2008 sample database. The purpose is to reveal a few attributes of an employee, given his or her unique EmployeeId.

Listing 48.1 A Stored Procedure for Your First Web Service

To expose this procedure as a web method of your web service, you use the CREATE ENDPOINT T-SQL statement, ...