¼òµ¥µÄsqlÊý¾Ý¿â´¥·¢Æ÷ʵÀý

--ͨ¹ýsqlÆóÒµ¹ÜÀíÆ÷Ð޸ĺÍɾ³ýa±íÖÐÊý¾Ýʱ»á³öÏÖ´íÎó
--sqlÆóÒµ¹ÜÀíBug£¬Í¨¹ý³ÌÐò»òÖ´ÐÐsqlÓï¾ä¸üÐÂa±íÊý¾ÝûÓÐÎÊÌâ
--Ìí¼Ó
Insert a (FName, FCode, FOther) Values('11','2222','33')
--ÐÞ¸Ä
Update a Set FName='22_Edit' Where FCode='22'
--ɾ³ý
Delete a Where FCode='22'
--²é¿´a/b±íÊý¾Ý
Select * from a
Select * from b
/*
--Insert
Create trigger a_insert
on a
--with encryption
after insert
as
Declare @FCode Varchar(100)
Declare @FName Varchar(100)
Declare @FID int
--inserted£º»ñÈ¡Ìí¼ÓµÄ¼Ç¼µÄÏà¹ØÐÅÏ¢
select Top 1 @FCode=a.FCode,@FName=a.FName,@FID=a.fid from a,inserted Where inserted.FID=a.FID
Insert Into b (FCode,FName,A_FID) Values(@FCode,@FName,@FID)
--Update
Alter trigger a_update
on a
--with encryption
after Update
as
Declare @FCode Varchar(100)
Declare @FName Varchar(100)
Declare @FID Varchar(100)
--deleted£º »ñÈ¡ÐÞ¸ÄÇ°¼Ç¼µÄÏà¹ØÐÅÏ¢
--inserted£º»ñÈ¡Ð޸ĺó¼Ç¼µÄÏà¹ØÐÅÏ¢
Update b Set FCode=i.FCode,FName=i.FName
from b ,Deleted d ,Inserted i
Where b.A_FID=d.FID
--delete
Alter trigger a_delete
on a
--with encryption
after delete
as
--deleted£º »ñÈ¡ÐÞ¸ÄÇ°¼Ç¼µÄÏà¹ØÐÅÏ¢
Delete b
from b , Deleted  d
Where b.A_FID=d.FID
*/