Επεξεργασία

Κοινή χρήση μέσω

Sample Recordset for Examining Data

  • Άρθρο

First, let's look at the Recordset object as returned using the following SQL query, executed against the Northwind sample data base in Microsoft SQL Server.

SELECT ProductID,ProductName,UnitPrice   
FROM Products   
WHERE CategoryID = 7

The resultant Recordset object contains all the produces in the database shown in the following table.

ProductID ProductName UnitPrice
7 Uncle Bob's Organic Dried Pears 30.0000
14 Tofu 23.2500
28 Rssle Sauerkraut 45.6000
51 Manjimup Dried Apples 53.0000
74 Longlife Tofu 10.0000

If you are interested in getting these results yourself, try the following JScript example: