摘要:
declare @woidpre varchar(50);declare @DMRNoExterior varchar(50);set @woidpre='DMR'+@WOID;select top 1 @DMRNoExterior=DMRNoExterior from dbo.F_DMRExterior where WOID=@WOID order by cast(reverse(left(reverse(DMRNoExterior),charindex('-',reverse(DMRNoExterior))-1)) as int) desc;if(@DMRN 阅读全文