摘要:
createprocproc_grade(@testnamevarchar(50),@gradeintoutput)asbeginselect@grade=mingcifrom(selectrow_number()over(orderbyscoredesc)asmingci,score,testn... 阅读全文
posted @ 2011-07-20 16:53 管志鹏 阅读(199) 评论(0) 推荐(0)
|
|||
摘要:
createprocproc_grade(@testnamevarchar(50),@gradeintoutput)asbeginselect@grade=mingcifrom(selectrow_number()over(orderbyscoredesc)asmingci,score,testn... 阅读全文
posted @ 2011-07-20 16:53 管志鹏 阅读(199) 评论(0) 推荐(0)
摘要:
insert 触发 createtriggertrig_testonscoreInfoforinsertasdeclare@testnamevarchar(50),@scoreint,@countintselect@testname=testname,@score=scorefrominsert... 阅读全文
posted @ 2011-07-20 16:51 管志鹏 阅读(199) 评论(0) 推荐(0) |
|||