这个触发器是什么意思。求教
--select cverifier,CGATHINGCODE,* from where CDLCODE=0000004538
CREATE TRIGGER . ON .
FOR update
AS
if update(cverifier) --and (select cverifier from inserted where cverifier<>'')
begin
if exists (select cverifier from inserted where cverifier<>'')
begin
declare @tmp varchar(400)
declare @str varchar(8000)
declare @str1 varchar(8000)
declare @kk varchar(400)
SELECT @str=CGATHINGCODE FROM inserted-- WHERE CDLCODE='0000004538'
set @kk=null
SELECT @kk= FROM where in
(select * from dbo.fsplit(@str,'/')) and is null
--set @tmp='收款单：订单号不符，请重新选择收款单！'
--raiserror(@tmp,16,10)
--print @kk
if @kkis not null
begin
set @tmp='收款单：'+@kk+'无订单号，请重新选择收款单！'
raiserror(@tmp,16,10)
end
set @kk=null
SELECT @kk= FROM where in
(select * from dbo.fsplit(@str,'/')) and not in
(select csocode from inserted)--DispatchList WHERE CDLCODE='0000004527')
if @kkis not null
begin
set @tmp='收款单：'+@kk+'订单号不符，请重新选择收款单！'
raiserror(@tmp,16,10)
end
end
end
页:
[1]