摘要：
1 SELECT TOP 200 2 PNo, IDENTITY( INT,1,1 ) AS sn 3 INTO 4 #temp1 5 FROM 6 tbl_test 7 8 SELECT 9 CASE WHEN sn = 10 11 AND sn = 100 THEN CONVERT(CHAR(3), sn) 1... 阅读全文
posted @ 2018-10-18 15:31 竹子柱 阅读(375) 评论(0) 推荐(0)
|
|
|
|
摘要：
1 SELECT TOP 200 2 PNo, IDENTITY( INT,1,1 ) AS sn 3 INTO 4 #temp1 5 FROM 6 tbl_test 7 8 SELECT 9 CASE WHEN sn = 10 11 AND sn = 100 THEN CONVERT(CHAR(3), sn) 1... 阅读全文
posted @ 2018-10-18 15:31 竹子柱 阅读(375) 评论(0) 推荐(0) |
|
浙公网安备 33010602011771号