27,579
社区成员
发帖
与我相关
我的任务
分享
declare @piaoh varchar(20)
SELECT TOP 1 @piaoh=piaoh from renwu (XLOCK,ROWLOCK) where caozuoyuan='' ORDER BY piaoh
我的博客里写的比较详细了:http://blog.csdn.net/yenange/article/details/79580519
alter proc get_renwu @caozuoren varchar(10)
as
--内部变量声明
declare @recnum integer,
@rowcount integer
set @recnum=0
declare @errcode integer
set @errcode=7300
declare @return integer
set @return=0
--启动事务处理
declare @tran_point int
set @tran_point=@@trancount
if @tran_point=0
begin tran abc
else
save tran abc
--获取最小票号
declare @piaoh varchar(20)
select @piaoh=MIN(piaoh) from renwu where caozuoyuan=''
--更新获取到的任务
update renwu set type=1,caozuoyuan=@caozuoren,lingqutime=CONVERT(varchar(23),GETDATE(),21) where piaoh=@piaoh
--写表
insert into renwu2
(riqi,piaoh,jine,type,caozuoyuan,lingqutime,intime)
select riqi,piaoh,jine,type,caozuoyuan,lingqutime,CONVERT(varchar(23),GETDATE(),21) from renwu where piaoh=@piaoh
if @tran_point=0
commit tran abc
goto return_lab
err_lab:
rollback tran abc
return_lab:
return @return