SoalChess的博客

SQL 取出某个表序列号中不连续的数字WITH table1(A) as (SELECT cast( xx as integer) FROM [dbo].[xxxxx] where xx like'010209%'),t AS ( SELECT A, ROW_NUMBER() OVER(ORDER BY A) rn FROM table1),r A...

菜鸟小新一枚：UPDATE a SET a.addr=a.addr+'-'+b.doorplate FROM takedata..workorder2019 aLEFT JOIN BaseData.dbo.Meterdoor b on a.regist_no=b.regist_nowhere WorkOrderType_Name='**' and book in (**)...