SQL
SoalChess
这个作者很懒,什么都没留下…
展开
-
SQL 取出某个表序列号中不连续的数字
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...原创 2019-12-26 11:03:43 · 1094 阅读 · 0 评论 -
觉得自己写了个棒棒的update
菜鸟小新一枚: UPDATE a SET a.addr=a.addr+'-'+b.doorplate FROM takedata..workorder2019 a LEFT JOIN BaseData.dbo.Meterdoor b on a.regist_no=b.regist_no where WorkOrderType_Name='**' and book in (**) ...原创 2019-11-29 17:21:11 · 158 阅读 · 0 评论