create trigger Trigger_Info on file_table
for insert
as insert into oamanager.dbo.UnionShow
(uMessageId,Log_sUserKey,uYNSee,uTitle,uBrief,uAnchor,uTime,uMark,Module_sKey,Fun_sKey,SysKey)
select
'111111',u.objuserkey,0,i.file_Title,i.file_Title,'../MessageExchange/info_show.aspx?index='+convert(varchar(50),i.file_ID),i.file_TitleTime,'','','','Key7055475115'
from user_table u,inserted i
where u.file_num=i.file_num
for insert
as insert into oamanager.dbo.UnionShow
(uMessageId,Log_sUserKey,uYNSee,uTitle,uBrief,uAnchor,uTime,uMark,Module_sKey,Fun_sKey,SysKey)
select
'111111',u.objuserkey,0,i.file_Title,i.file_Title,'../MessageExchange/info_show.aspx?index='+convert(varchar(50),i.file_ID),i.file_TitleTime,'','','','Key7055475115'
from user_table u,inserted i
where u.file_num=i.file_num
WHILE (@@FETCH_STATUS=0)
Begin
FETCH NEXT FROM myCusor into
@objuserkey ============>FETCH NEXT FROM myCusor into
@objuserkey WHILE (@@FETCH_STATUS=0)
Begin 先fetch再判断
我事说在这个题目中我没看出你的跟楼主的区别来,如果楼主那个又问题,用你的语句一样不行