＝这个update触发器怎么写？

[blackwind]

CREATE TABLE [dbo].[Service_USER] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[YD_LT] [bit] NOT NULL ,
[ServiceName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ServiceID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Mobile] [char] (11) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Corp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Dept] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[OrderTime] [datetime] NOT NULL ,
[Status] [bit] NOT NULL
) ON [PRIMARY]

如果更新Service_USER这张表的Status字段，从0到1,并且ServiceName＝‘企业定制’
则插入一条记录到send_quick表。

CREATE TABLE [dbo].[SEND_QUICK] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Mobile] [char] (11) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Content] [varchar] (140) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ServiceName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ServiceID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
) ON [PRIMARY]

要求SEND_QUICK.mobile=Service_USER.mobile,
SEND_QUICK.servicename=Service_USER.servicename,
SEND_QUICK.serviceid=Service_USER.serviceid,

[dlkfth]

if update(Status) --是否更新Status列
begin
end

其它的我想你应该会写

[wzh1215]

----符合一条一条的修改
CREATE TRIGGER [TRGNAME] ON [Service_USER]
FOR UPDATE
AS
if update(Status)
begin
if (select status from deleted where ServiceName='企业定制')='0' and (select status from inserted where ServiceName='企业定制')='1'
insert SEND_QUICK(Mobile,Content,ServiceName,ServiceID)
select Mobile,'这里不知楼主想要什么',ServiceName,ServiceID from Inserted
end

[newdongkui]

CREATE TRIGGER updService_USER
ON Service_USER
FOR update AS

IF UPDATE ( Status )
BEGIN
declare @statusold bit,@statusnew bit,@ServiceName varchar(50)

select @statusold = status from deleted
select @statusnew = status ,@ServiceName = ServiceName from inserted

if @statusold =0 and @statusnew = 1 and @ServiceName＝‘企业定制’
insert into SEND_QUICK (mobile,servicename,serviceid)
select mobile,servicename,serviceid from inserted

END