Beginning with SQL Server 2000, Microsoft added support to retrieve data from SQL Server databases by using an URL address. To do this, you must create a virtual root, that is, a virtual address that your Website visitors can see. To do that, use the ‘Configure SQL XML Support in IIS’ utility that comes with the SQL Server 2000 installation. Then, you can send queries by URL.
Example:
‘http://myWebServerName/myVirtualRootName?sql=SELECT+FirstName+FROM+Employees’
The results are in XML format, so there’s no ASP needed. The ‘+’ signs exist to substitute the normal spaces that, as you know, are forbidden from usage in URL addresses. Enjoy!
Top Careers at Microsoft
February 3, 2023
Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job
