Declare @FBillNO Varchar(12),@Fdate Char(5),@i Int,@FB Varchar(12)
if NOT exists(Select FBiLLNo From inserted Where Left(FBiLLNo,2) = 'WB' or Left(FBiLLNo,2)='W2')
Begin
Select @FBillNO = b.FBillNO From INSERTED a,SeOrder b Where a.FOrderinterID = b.FInterID
Select @Fdate = Right(Convert(VarChar(6),FCheckDate,112),5) ,@FB = FBillNo From INSERTED
If left(@FBillNO,2) = 'DB'
Begin
Select @i=Cast(Isnull(Right(Max(FBillNO),4),'0') As Int)+10001
From ICMO
Where FBillNo like 'WB'+ @Fdate+'-%'
Update ICMO Set FBillNO= 'WB'+ @Fdate+'-'+Right(@i,4)
Where FBillNo=@FB
End
Else
Begin
Select @i=Cast(Isnull(Right(Max(FBillNO),4),'0') As Int)+10001
From ICMO
Where FBillNo like 'W2'+ @Fdate+'-%'
Update ICMO Set FBillNO= 'W2'+ @Fdate+'-'+Right(@i,4)
Where FBillNo=@FB
End
End
GO
SET ANSI_NULLS ON
GOCREATE Trigger trgUpdDept ON dbo.bas_dept
FOR UPDATE
AS
IF update(bas_no)
begin
declare @del_no char(10)
select @del_no=d.bas_no from deleted d
--1
update bas_zzry
set dept_no=i.bas_no
from inserted i
where dept_no=@del_no
--2
update bas_dwzs
set dept_no=i.bas_no
from inserted i
where dept_no=@del_no
--3
update bas_zrjhk
set dept_no=i.bas_no
from inserted i
where dept_no=@del_no
endGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
,,,::::t:MMMMMMMMMBVt:+..
,IVXVYIBttt+::+IVVMMMMMMRR:‘
,YYVYItMYti+i++:X+Rt:tXWRMR,
.YRiIYRMViitVXRWRYMI++++itMM..
.Y+,.,X::,,,YMMMMMMMMRVItXMti
:X+:,X:,. .,iiIRMWMMMBBRMMBY.
tR+:I:i:+Y:IitYVYMMMMMMMMRi.
.+RXt:,::.::XXIBMMMMMMMMM+:
,RRXitY+,.::RWMMMMMMMMt.
VYI:::,..:tVMMMMMMBY+.
.VBBW:::::,i.MMMMMBi:.
.tWRRVi:::.X:VMMMMMMY.
,+i+:,XYtt+:,i:,MMMBR:
...VV..:..:.tt::++:+,RMYMV.
:M:::..:,.:,,,.+t+++Ytt.,+:
tRt:,.:,.:,:.:+.,:++tit,
:tXt:,:,:.:.,,+,:+YRY,
:++:::.,:.:.::+:iMi
,Ri:::,:::::::+Ii
,+:Xii:,,::I:tit,.
:BBt,:+::,::i+.
:BWXX::::::iX.
:BWVIi++t+:V+
WBXtItii+iWI.
:MWIYIti+iVRY,
RBXVYItiiIYXWI,
:MRWWVYttttIIXWt.
.XMBRRXIti++itIXW,
.BMBBRVIi+::+ttXX.
,MMBRXYti:::+tIW:
tMMRWYti+++ittXV
+MRVYti+++ittWI
.VMWVtiiiiiitIR,
.XBBWVttttttttXRv
.,WBRBXVtttttttIWt
:RWXWBXYtttttttYR:
.iRWVIiBWYIttttttYW,
.tWVYti:WRVIttittIVV .:,,
tWVIi++:XRVIIttttIXY ..:YYtYi:tittV,
tXYti+++tWRVYttittYWIiIYYVItt:iXW+....
:WIt+++iXRBBVYItitIYXXYti+iIYt++:IMRi:.
.:Xti+:+tRWt:BVYItitIYWVIIIYXXWXVXYt+i+IV:
.tYi+::IWI:::BVVItitIXBRVIt:::::::tIVXRiXt
:Viii++i:itIXBXVttitVW, tBIX
.XIiXIttIVRBRBIItttIRX :VX
.,tXXWWWVi+. RXXItiYRV ..
,BWYi+IRX
tBYiitWB,
.WVtiiIRI
VWtiiiIB,
,BIiiiiWt
.BViiiiYV
XXtii+YV
iRiii+YY
:Btii+XI
Wtii+R:
XY+t+B.
YX+tYR.
tX+iWV
iXi+RI
tYiIXX
,XtiIXRt.
:BIVYRWIV
+RYXXWiYR.
iWIVYtXMV
tBYItRtM+
XBWttX:B:
YYBXXYR:,R:
GO
CREATE PROCEDURE WageIncrease
AS
UPDATE Employee SET Wage=Wage*1.1
GO