.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> SQL Query >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Create Web Services in SQL Server

Posted By:Lakhan Pal Garg       Posted Date: November 03, 2009    Points: 10    Category: SQL Query    URL: http://www.dotnetspark.com  

If you want to create web service using SQL Query you can use below SQL code to create that using SQL Server, and its very simple.
 

Below is the code snippets to Create Web Services in SQL Server.

CREATE ENDPOINT XMLHTTPEndPoint   /* Create End Point for web service.*/

STATE= {STARTED | STOPPED | DISABLED} /* STARTED Means Listening and Responding, DISABLED Means Neither Listening nor Responding And STOPPED Means Listening But Not Responding*/

AS
{HTTP | TCP} /* specify the Transport Protocol to used */
(
PATH =  (e.g.: '/Webservices',)

AUTHENTICATION= (BASIC | DIGEST | INTEGRATED),
/* INTEGRATED Is More Secure, While Basic is Least Secure and Digest is not Secure Authentication type */

PORTS= {CLEAR | SSL}, /* CLEAR (HTTP - port 80 by default) SSL (HTTPS - port 443 by default) */

SITE= 
)
FOR {SOAP | TSQL}
 (
WEBMETHOD 
(NAME=),

BATCHES= {ENABLED | DISABLED},
/* If ENABLED, multiple SOAP request/response message pairs can be identified as part of a single SOAP session. */

WSDL= {NONE | DEFAULT | 'sp_name'},
DATABASE = 
NAMESPACE= http:///
)

WSDL Specify how the Document Generation Will Occur. If none no Response is generated or returned for query.

Thanks & Regards
Lakhan Pal Garg


     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend