当我创建触发器时显示错误 [英] When I creating trigger shows error

问题描述

以上是在sql server 2008中做的





tblemployeedetailsas



id int

名称Varchar（50）

薪资变量（50）

性别变量（50）

Deptid int





Tblaudit如下



id int

Auditdata varchar（50）





i我在tblemployeedetails中插入记录时创建一个触发器，在tblaudit中记录将被插入。为此我创建一个触发器如下。





创建triggger tbl_insert_foremployee

on tblemployeedetails
for insert

AS



BEGIN

声明@id int

从插入中选择@id = id

插入到Tblauditdata

值（'新员工id ='+ cast（@id as varchar（5））+

'添加在'+ cast（Getdate（）as nvarchar（20）））

END

GO





当我执行上述触发器时显示错误如下



未知对象类型'triggger'用于CREATE，DROP或ALTER语句。



请帮我解决我犯的错误。



我尝试了什么：

以上是在sql server 2008中做的
 
 
 tblemployeedetailsas跟随
 
 id int 
名称Varch ar（50）
 Salary Varchar（50）
 Gender Varchar（50）
 Deptid int 
 
 
 Tblaudit如下
 
 id int 
 Auditdata varchar（50）
 
 
i每当插入tbmpudeedetails中的tblemployeedetails中的记录时，都会创建一个触发器。因为我正在创建一个触发器，如下所示。 
 
 
创建triggger tbl_insert_foremployee 
 on tblemployeedetails 
 for insert 
 AS 
 
 BEGIN 
声明@id int 
从插入的
中选择@id = id插入到Tblauditdata 
值（'id ='+ cast的新员工（@id as varchar（5））+ 
'被添加到'+ cast（Getdate（）as nvarchar（20）））
 END 
 GO 
 
 
当我执行上述触发时显示错误如下
 
 CREATE，DROP或ALTER语句中使用的未知对象类型'triggger'。 
 
请帮我解决我犯的错误。

解决方案

取出'g'.. 。

创建triggger tbl_insert_foremployee 

应该是：

创建触发器tbl_insert_foremployee 

 CREATE TRIGGER [dbo]。[triggername] ON [dbo]。[tablename] AFTER INSERT 

The above one is doing in sql server 2008


tblemployeedetailsas follows

id int
Name Varchar(50)
Salary Varchar(50)
Gender Varchar(50)
Deptid int


Tblaudit as follows

id int
Auditdata varchar(50)


i am creating a trigger whenever record inserted in the tblemployeedetails, in tblaudit record will be inserted. for that i am creating a trigger as follows.


create triggger tbl_insert_foremployee
on tblemployeedetails
for insert
AS

BEGIN
declare @id int
select @id = id from inserted
insert into Tblauditdata
values ('New employee with id = ' + cast(@id as varchar(5)) +
'is added at ' + cast(Getdate() as nvarchar(20)))
END
GO


when i execute the above trigger shows error as follows

Unknown object type 'triggger' used in a CREATE, DROP, or ALTER statement.

please help me what is the mistake i made.

What I have tried:

The above one is doing in sql server 2008


 tblemployeedetailsas follows

   id       int 
   Name     Varchar(50)
   Salary   Varchar(50)
   Gender   Varchar(50)
   Deptid   int 


 Tblaudit as follows

  id           int
  Auditdata    varchar(50)


i am creating a trigger whenever record inserted in the tblemployeedetails, in tblaudit record will be inserted. for that i am creating a trigger as follows.


 create  triggger tbl_insert_foremployee
 on tblemployeedetails
 for insert
 AS
 
 BEGIN
    declare @id int
    select @id = id from inserted
    insert into Tblauditdata
    values ('New employee with id =  ' + cast(@id  as varchar(5)) +
    'is added at ' +  cast(Getdate() as nvarchar(20)))
 END
 GO


when i execute the above trigger shows error as follows

Unknown object type 'triggger' used in a CREATE, DROP, or ALTER statement.

please help me what is the mistake i made.

解决方案

Take out a 'g'...

create  triggger tbl_insert_foremployee

should be:

create  trigger tbl_insert_foremployee

CREATE TRIGGER [dbo].[triggername] ON [dbo].[tablename] AFTER INSERT

这篇关于当我创建触发器时显示错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！