以上是在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_foremployeeshould be:
create trigger tbl_insert_foremployeeCREATE TRIGGER [dbo].[triggername] ON [dbo].[tablename] AFTER INSERT更多推荐
当我创建触发器时显示错误
发布评论