读书人

不能创建触发器。解决方法

发布时间: 2011-12-27 22:22:55 作者: rapoo

不能创建触发器。
ALTER TRIGGER tttttt ON RAIN
FOR INSERT
AS
DECLARE @stcd char(10)
DECLARE @tm datetime
DECLARE @v float
declare @mark int
declare @type int
select @stcd=stcd,@tm=tm,@v=rn,@mark= '0 ',@type= '1 ' from inserted
insert into outstr(stcd,tm,v,mark,type) values (@stcd,@tm,@v,@mark,@type)

错误208:对象名:tttttt无效。

我发现我的SQL好像就是创建不了触发器,真奇怪了。。。郁闷ing

[解决办法]
CREATE TRIGGER tttttt ON RAIN
FOR INSERT
AS
DECLARE @stcd char(10)
DECLARE @tm datetime
DECLARE @v float
declare @mark int
declare @type int
select @stcd=stcd,@tm=tm,@v=rn,@mark= '0 ',@type= '1 ' from inserted
insert into outstr(stcd,tm,v,mark,type) values (@stcd,@tm,@v,@mark,@type)
[解决办法]
ALTER 是修改,用Create

CREATE TRIGGER tttttt ON RAIN
FOR INSERT
AS
DECLARE @stcd char(10)
DECLARE @tm datetime
DECLARE @v float
declare @mark int
declare @type int
select @stcd=stcd,@tm=tm,@v=rn,@mark= '0 ',@type= '1 ' from inserted
insert into outstr(stcd,tm,v,mark,type) values (@stcd,@tm,@v,@mark,@type)
[解决办法]
ALTER TRIGGER 是在你的器tttttt 存在的候用的,如果tttttt 不存在,用CREATE TRIGGER

读书人网 >SQL Server

热点推荐