我在ADOQuery1中用如下sql语句:
CREATE TRIGGER trig_tableAxisTrail ON dbo.tableAxisTrail
FOR INSERT
AS
declare @Eid int,
@Longitude int,
@Latitude int,
@Direction int,
@Dtime Datetime
select @Eid=Eid,
@Longitude=Longitude,
@Latitude=Latitude,
@Direction=Direction,
@Dtime=Dtime
from insertedinsert into Trail
values(@Eid,@Longitude,@Latitude,@Direction,@Dtime)
运行后触发器能生成,但同时出现如下错误:
“CommandText does not return a result set"
应如何解决?
CREATE TRIGGER trig_tableAxisTrail ON dbo.tableAxisTrail
FOR INSERT
AS
declare @Eid int,
@Longitude int,
@Latitude int,
@Direction int,
@Dtime Datetime
select @Eid=Eid,
@Longitude=Longitude,
@Latitude=Latitude,
@Direction=Direction,
@Dtime=Dtime
from insertedinsert into Trail
values(@Eid,@Longitude,@Latitude,@Direction,@Dtime)
运行后触发器能生成,但同时出现如下错误:
“CommandText does not return a result set"
应如何解决?
依照这个错误信息来看,估计如楼上所说,用execute来试试看