62,243
社区成员




CREATE TRIGGER UpDateUnionSendOrder ON [dbo].[Cli_OrderFormList]
FOR INSERT
AS
Begin
Declare @OrderNum nvarchar(100),
@OrderProName nvarchar(50),
@OrderProNum nvarchar(50),
@OrderProPrice nvarchar(50),
@OldInfo nvarchar(500),
@ThisInfo nvarchar(200),
@NewInfo nvarchar(500)
Select @OrderNum = Ofl_OrderID,@OrderProName = Ofl_BrandName + '('+ Ofl_BrandType +','+Ofl_Color+')',@OrderProNum = Ofl_BuyNum, @OrderProPrice = convert(nvarchar,Ofl_ProPrice) from inserted
Select @OldInfo = IsNull(OrderInfor,'') from UnionSendOrder Where OrderNum = @OrderNum
Select @ThisInfo = '||'+@OrderProName+'@'+@OrderProPrice+'@'+@OrderProNum
If @OldInfo <> ''
Begin
Select @NewInfo = @OldInfo + @ThisInfo
End
Else
Begin
Select @NewInfo = @ThisInfo
End
---declare @Sql nvarchar(200)
---set @Sql = 'Update UnionSendOrder set OrderInfor = '''+@NewInfo+''' Where OrderNum ='''+ @OrderNum + ''''
Insert into NNNS(NNN) Values(@NewInfo)---这里可以正常执行
--exec(@Sql) ----我把SQL语句放查询分析器里也执行.....
Update UnionSendOrder set OrderInfor = @NewInfo Where OrderNum = @OrderNum ---这里不执行
End
create table AAA
(
[username] varchar(25) null,
[username1] varchar(25) null,
[username2] varchar(25) null,
)
CREATE TRIGGER insertAAA on AAA
for insert
as
begin
insert into AAA(username,username1,username2) values('1','2','3')
--分开更新,多操作没问题
update AAA set username1 = '111'
update AAA set username2 = '222'
end
insert into AAA(username) values('000')
select * from AAA