September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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, ...