急!急!急!请各位SQL-SERVER 2000高手务必过来看一下,高分赠送!!
1.You are a database developer for Wingtip Toys.You have creeated an order
entry database that includes two tables,as shown below: Users enter orders into the entry application.When a new order is entered, the data is saveed to the Order and LineItem tables in the order entry database.You must ensure that the entire order is saved successfully.
Order
PK OrderID
CustomerID
OrderDate
LineItem
PK temID
OrderID FK_reference order OrderID
ProductID
Price
What should you do?
2.编一个添加学校记录的存储过程。(即做一个插入的存储过程,但也可能用到触发器)
要求:
保证在其他表格中相应的数据也要插入。
(1)城市表(城市编号,城市名,隶属省编号)
(2)学校(学校编号,学校名称,邮政编码,城市编号,学校类别,县、市名)
(3)班级(班级编号,班级名,学校编号,学年)
请会这两题的高手把代码也写上,谢谢!截止日期:6.27