????sp_password
??????????????????????
????sp_helptext
?????????????δ?????洢?????????????洢??????????????????????????
????????洢???????
????CREATE  PROC[EDURE]  ?洢??????
????@????   ???????? = ???? OUTPUT??
????@????n  ???????? = ???? OUTPUT
????AS
????SQL???
?????????????
???????????
???????????????????????????
?????????????????????
????EXEC  ??????  [????]
????????????????????????洢?????????????????????????洢?????
????????洢????????洢??????????????????????????????????????д?????????С?
????????????????????????????????????????仯?????????С???????????????SQL Server??????????????????????飬????????????????????????????????
??????????????????????SQL Server???????????????????????????????????????????е???γ???????????????????洢?????
??????????????????????????????Insert ?? Update ?? Delete ???
??????????
CREATE TRIGGER triggerName ON Table
for UPDATE|INSERT|DELETE
AS
begin
…
end
??????????-????
CREATE TRIGGER testForFun ON dbo.Category
for UPDATE
AS
begin
select * from book
end
update Category set c_name = 'Android2' where c_id=3
??????????-???
CREATE TRIGGER testForDel ON dbo.Category
for delete
AS
begin
select * from book
end
delete Category set c_name = 'Android2' where c_id=3