CREATE TRIGGER rdrecord_iDLsID
on rdrecord
for insert,UPDATE
as
declare @ID int
declare @cHandler varchar(20)
declare @Icount int
DECLARE authors_InUp CURSOR FOR
SELECT dbo.DispatchList.dlID, inserted.cHandler, COUNT(*) AS Expr1 FROM dbo.DispatchList INNER JOIN
dbo.DispatchLists ON dbo.DispatchList.dlID = dbo.DispatchLists.dlID INNER JOIN
dbo.RdRecords ON dbo.DispatchLists.iDLsID = dbo.RdRecords.iDLsID INNER JOIN
inserted ON dbo.RdRecords.ID = inserted.ID
GROUP BY dbo.DispatchList.dlID, inserted.cHandler
open authors_InUp红字那段是什么意思????
on rdrecord
for insert,UPDATE
as
declare @ID int
declare @cHandler varchar(20)
declare @Icount int
DECLARE authors_InUp CURSOR FOR
SELECT dbo.DispatchList.dlID, inserted.cHandler, COUNT(*) AS Expr1 FROM dbo.DispatchList INNER JOIN
dbo.DispatchLists ON dbo.DispatchList.dlID = dbo.DispatchLists.dlID INNER JOIN
dbo.RdRecords ON dbo.DispatchLists.iDLsID = dbo.RdRecords.iDLsID INNER JOIN
inserted ON dbo.RdRecords.ID = inserted.ID
GROUP BY dbo.DispatchList.dlID, inserted.cHandler
open authors_InUp红字那段是什么意思????
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货