解开未完成的事务，用变量接收另一个存储过程反回的值

declare @iEquipmentID int, @ISort int, @cType varchar(32), @cBillCode nvarchar(32), @cOperator varchar(12)
    
    select @iEquipmentID = IDENT_CURRENT('tEqaEquiDetail');
    select @cOperator=cOperator from tEqaEquiDetail where iEquipmentID = @iEquipmentID
    set @ISort = 1
    set @cType = '新增'
    
    create table #temp
    (
        cValue varchar(1024) null
    )
    set @sql = 'insert into #temp(cValue) exec dbo.pSysGetCode '''','''',-1,-1,''cBillCode_change_eqa'''
    exec (@sql);
    select @cBillCode = cValue from #temp
    drop table #temp;
    
    if @@error != 0
    begin
        goto problem
    end
    
    insert into tEqaChange (iEquipmentID, ISort, cType, cBillCode, dBill, dCreate, cOperator)values
    (@iEquipmentID, @ISort, @cType, @cBillCode, GETDATE(), GETDATE(), @cOperator)

select *  from sys.dm_tran_locks where resource_type = 'OBJECT' and resource_database_id = (select DB_ID())
DBCC OPENTRAN; 反回结果
kill 360

南来地,北往的,上班的,下岗的,走过路过不要错过!

======================个性签名=====================

之前认为Apple 的iOS 设计的要比 Android 稳定,我错了吗?

下载的许多客户端程序/游戏程序,经常会Crash,是程序写的不好(内存泄漏?刚启动也会吗?)还是iOS本身的不稳定!!!

如果在Android手机中可以简单联接到ddms,就可以查看系统log,很容易看到程序为什么出错,在iPhone中如何得知呢?试试Organizer吧,分析一下Device logs,也许有用.

我的开发工具