日期:2014-05-18  浏览次数:20772 次

为什么我的这个简单的触发器总报错!!!
为什么我的这个触发器,总报错.
--------原码---------------
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [HBTrigger_YellowPagesQuery_Delete] 
  ON [dbo].[YellowPages_Query] 
  for delete
AS 
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

  insert into HBTrigger_YellowPagesQuery select id, 'Delete', '' from Deleted

END
-------------------------

错误:
消息 208,级别 16,状态 6,过程 HBTrigger_YellowPagesQuery_Delete,第 16 行
对象名 'HBTrigger_YellowPagesQuery_Delete' 无效。

------解决方案--------------------
SQL code
create TRIGGER [HBTrigger_YellowPagesQuery_Delete]