SELECT
(SELECT COUNT(*) FROM T WHERE [PK] <= a.[PK]) AS id
,xm,xb
FROM T aSELECT
(SELECT COUNT(*) FROM T WHERE xm + xb <= a.xm + a.xb) AS id
,xm,xb
FROM T a
(SELECT COUNT(*) FROM T WHERE [PK] <= a.[PK]) AS id
,xm,xb
FROM T aSELECT
(SELECT COUNT(*) FROM T WHERE xm + xb <= a.xm + a.xb) AS id
,xm,xb
FROM T a
SELECT * FROM #t
GO
DELETE T
GO
SET IDENTITY_INSERT T ON
INSERT T(id,xm,xb) SELECT id,xm,xb FROM #t
SET IDENTITY_INSERT T OFF
GO
DROP TABLE #t
GO
无法使用 SELECT INTO 语句向表 '#t' 中添加标识列,该表中已有继承了标识属性的列 'id'。gmlxf(烛光) 很厉害,就指望你了分不够我再加50
这样,我的记录数就从4,5...开始
我能问问为什么这么写能提到序数,谢谢
--
xm,xb需要是非标志列
SELECT (SELECT COUNT(*) FROM oa_util_sp WHERE spid <= a.spid AND fid = a.fid) AS id
,* FROM oa_util_sp a
WHERE fid=32
(SELECT COUNT(*) FROM T WHERE xm + xb <= a.xm + a.xb) AS id
,xm,xb
FROM T a
的原理外我还想问,这个临时表是不是用完就删除啊!