SQL Server
teamleaf
这个作者很懒,什么都没留下…
展开
-
存储过程
use pubsCREATE PROCEDURE p_au_info_allASSELECT au_lname, au_fname, title, pub_name FROM authors a FULL JOIN titleauthor ta ON a.au_id = ta.au_id FULL JOIN titles t ON t.title_id = ta.tit翻译 2008-05-01 13:03:00 · 207 阅读 · 0 评论 -
触发器练习
---XS_KC 通过触发器限制"学号"列必须在XS表中存在学号create TRIGGER check_trig ON XS_KC FOR INSERT,updateASif exists(SELECT * FROM inserted a WHERE a.学号 NOT IN (SELECT b.学号 FROM XS b翻译 2008-05-01 13:10:00 · 466 阅读 · 0 评论