數(shù)據(jù)庫技術(shù)實驗六-文庫吧資料
2025-07-19 23:13本頁面
【正文】 sbegindeclare a int,b intset a=(select workyear from inserted)set b=(select workyear from deleted)if(ab)update Salaryset ine=ine + (ab)*500where enployeeid in(select EmployeesID from inserted)endupdate Employeesset workyear=12where EmployeesID=39。create trigger Salaryins0 on Salaryfor insert,update asbeginif(select employeeid from inserted) not in(select EmployeeID from Employees)rollbackendcreate trigger Employeesupdate0 on for updateasbeginupdate Salaryset employeeid=(select employeeid from inserted)where employeeid=(select employeeid from deleted)endcreate trigger Employeesdelete0 on Employeesfor deleteasbegindelete from Salarywhere employeeid=(select employeeid from deleted)end（2）當(dāng)修改表Employees時，若將Employees表中員工的工作時間增加1年，則將收入增加500，若增加2年則增加1000，依次增加。 fetch next from mycursor into edu,part_count,a
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1