XML and the SQL 2000 Server part 3: XML Data with XPath Queries - Testing an Xpath Query Using the Internal Tester
(Page 6 of 8 )
As mentioned previously the XML View Mapper also has a Xpath query tester program that can be invoked by clicking the XPath query Tester from the Tools drop down menu [or key F5] seen in an earlier screen shot. The Xpath query tester can also be invoked by right cliking the Mappings .smm file and choosing the Xpath query Tester. This brings up the following screen which initiates and completes the loading of the SQL information.
Clicking OK to this screen now brings up the query tester where in you can enter an Xpath query as shown in the next picture. When you click execute it will return an XML document which is produced by your query. The earlier SQL queries in Part 1, and Part 2 returned rowsets. Also notice the XPath query is posed against the database, and that is the reason you see the connection information. If the server is not running you will be asked to make a new connection. It is best to verify the connection before running the query.
Next: Exporting Schema and Query in URL >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
