다음을 통해 공유

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 2000.

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 Rössle 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: