当我创建触发器时显示错误

本文介绍了当我创建触发器时显示错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

以上是在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