OleDbCommand调用select and update 语句stored procedure,update返回执行结果.
OleDbCommand调用select and update 语句stored procedure,update返回执行结果.
---------------------------------------------------------------------
stored procedure:
CREATE Proc dbo.XX
(
@uniqueTransId varchar(10),
@numDaysAdded int,
@orgId int,
@fundId int
)
AS
set nocount on
begin
update tbl_Transaction
set CurEFTId = @uniqueTransId ,DateUpdated=getdate()
where TransactionStatusId = 44 and ScheduledProcessDate <= getDate() + @numDaysAdded
and TransactionTypeId = 144 and IsFeeReversal = 4 and CurEFTId is null and rganizationId = @orgId AND FundId = @fundId
select Id, FundEntryId, GroupId from tbl_Transaction where CurEFTId = @uniqueTransId
end
GO
------------------------------------------------------
C#
DataSet tsd = new DataSet();
adptrT.Fill(tsd, "Ta");
-------------------------------------------------------
tsd中应该只有select的结果集,但实际中update操作结果也被返回在DS中.
好个调查...原因为tbl_Transaction trigger中有一句select...导致DS中返回两个Table
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12476590/viewspace-263652/ ，如需转载，请注明出处，否则将追究法律责任。
