c# - 嗨，我有 table 。一个表，该表的col的rev_levl的int值为01我需要为当前值添加+01

蛋：

Rev_lev
   01     //it need to increment like below


Rev_Lev
   01
   02    //lik this

我做了下面的查询，但它检索到2。帮帮我
................................................... .............

select max(0+ rev_level+1)test from [Mettallurgical_WI_ENGG_Upload]
where Part_Number='ABB001'

最佳答案

检查一下。

    SELECT RIGHT('0'+ISNULL(CAST(max(rev_level)+1 as varchar(2)),''),2)
    from #Mettallurgical_WI_ENGG_Upload
    where Part_Number='ABB001'

关于c# - 嗨，我有 table 。一个表，该表的col的rev_levl的int值为01我需要为当前值添加+01，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/42918454/