求一个存储过程
phdmm 2015-05-11 08:50:07 @barcode,@workSpace为存储过程输入值
//1 从producttrack表中找到当前条码所在的workSpaceNow表(该表每个barcode对应只有一行)
//如果workSpaceNow不等于maintain,@workSpace=查询的结果
select workSpaceNow from producttrack where barcode =@barcode
//flowid
select flowid from producttrack where barcode =@barcode
//2 删除maintain表中条码为当前条码,并且flag为0或4的行
delete from maintain where barcode =@barcode and (flag=0 or flag=4)
//3 查找workSpaceNow表中条码信息
select * from @workSpace where barcode =@barcode
//4 如果3查找结果有记录,则更新记录,没有则插入
update @workSpace set flag=0 where barcode =@barcode
insert into @workSpace (barcode,flowid,flag)values(@barcode,@flwoid,0)
//最后返回是否执行成功