SQL Experts

Http Endpoint in sql server 2005

thangaraj — Wed, 25 Mar 2009 05:52:50 GMT

For Creating the Endpoint we do the following steps.

First We Create the sp.

CREATE PROCEDURE dbo.getSalesByTerritory AS
BEGIN
SELECT
t.Name,
SUM(s.SalesYTD) AS [TotalSalesYTD],
SUM(s.SalesLastYear) AS [TotalSalesLastYear]
FROM
Sales.SalesPerson s
INNER JOIN Sales.SalesTerritory t ON s.TerritoryID = t.TerritoryID
GROUP BY
s.TerritoryID, t.Name

RAISERROR ('Finished the execution of procedure.', 16, 1)
END

Then We Create the Endpoint

CREATE ENDPOINT AdventureWorksEP
STATE = STARTED
AS HTTP
(
PATH = '/sql',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = '*'
)
FOR SOAP
(
WEBMETHOD 'getSalesByTerritory'
(NAME = 'AdventureWorks.dbo.getSalesByTerritory'),
WEBMETHOD 'getServerInfo'
(NAME = 'AdventureWorks.dbo.getServerInfo'),
WEBMETHOD 'getServerVersion'
(NAME = 'AdventureWorks.dbo.getServerVersion'),
WSDL = DEFAULT,
SCHEMA = STANDARD
)
GO

Here For Webmethod we just refer the database name and Stored procedure name. My doubt is i want to pass the value to the Webmethod and based on that i need to retrive the values weathere its Possible.Please Explain.

Http Endpoint in sql server 2005

thangaraj — Wed, 25 Mar 2009 05:52:35 GMT

For Creating the Endpoint we do the following steps.

First We Create the sp.

Then We Create the Endpoint