一个关于cursor的题，求解，谢谢
In the task,you will complete a cursor that inserts data into atable,When complete,the script creats a cursor that read every type
from the titles table,determines the average price for titles of titles
of that type.and then inserts the information into the types table.<br/>
The script is supposed to do the following:<br/>
a. Create a read-only cursor called type_insert on titles that <br/>
queries distinct data in the type column.<br/>
b. Declare two variables:a char(12) value called @type and a <br/>
money variable called @avg_price.<br/>
c. Open the cursor and fetch the first row into a targer list.<br/>
d. While there are rows remaining,calulate the average price for
the fetched type,insert the appropriate information into the<br/>
types table,and fetch the next row.<br/>
e. Display the data in the types table.<br/>
<br/>
题目就是这样的，用到pubs2里的titles表，这个题里需要新建一个types表，从titles里取一条数据，处理之后就放在types里，请会的人帮我写一下或者点一下思路吧，我实在不会了。谢谢
页:
[1]