Browse by Tags

• C#
• Sample Code
• Web
• Web Service
• XML

• Sample code to create Native XML Web Service using SQL 2005 Transact-SQL script

  "CREATE ENDPOINT" Transact-SQL allows us to create Native XML Web services using Transact-SQL. (Refer Books online for details) The beauty of this example is: neither we create web service project in visual studio, nor we need data access layer to access Read More... Posted Tuesday, October 24, 2006 4:15 PM by PDesai | 6 Comments Filed under: SQL, Web Service, C#, XML, Sample Code, Web

• SQL Server 2005 Native XML Web Service

  Microsoft SQL Server 2005 Native XML web service enables us to make SOAP requests to SQL Server 2005 over HTTP. You can executes 1. SQL Batch statements 2. Stored Procedures 3. and scalar valued User defined functions How does it work? Simplely we create Read More... Posted Tuesday, October 24, 2006 4:01 PM by PDesai | 2 Comments Filed under: SQL, Web Service, C#, XML