create procedure _IsTestingIceBoxSerial
@_strRoomLeftString char(20),
@_Address char(20),
@_IsSpec char(10)
as
set @_strRoomLeftString=@_strRoomLeftString+'%'
if @_IsSpec='Prj'
select prj.IceBoxSerial,Prj.TestStandard,Prj.Address,IceModel,Project,EstradeNum from TaskBookPrj Prj,TaskBook where (Prj.State=1 or Prj.State=3) and Prj.EstradeNum Like @_strRoomLeftString and Prj.TestID=TaskBook.TestId and Prj.Address=TaskBook.Address and Prj.TestAddress=@_Address
@_strRoomLeftString char(20),
@_Address char(20),
@_IsSpec char(10)
as
set @_strRoomLeftString=@_strRoomLeftString+'%'
if @_IsSpec='Prj'
select prj.IceBoxSerial,Prj.TestStandard,Prj.Address,IceModel,Project,EstradeNum from TaskBookPrj Prj,TaskBook where (Prj.State=1 or Prj.State=3) and Prj.EstradeNum Like @_strRoomLeftString and Prj.TestID=TaskBook.TestId and Prj.Address=TaskBook.Address and Prj.TestAddress=@_Address
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货