还是序号的问题

INSERT tab_mingxi (xh,XMID,bjbh)
SELECT xh=1+isnull((select count(*) from jianguan.dbo.tab_baojianmingxi a where bjbh<a.bjbh ),0),XMID,bjbh from tab_test
运行结果序号都是为1？怎样才能生成连续序号？

---------------------------------------------------------------

INSERT tab_mingxi (xh,XMID,bjbh)
SELECT xh=1+isnull((select count(*)
from jianguan.dbo.tab_baojianmingxi a
where tab_test.bjbh<a.bjbh ),0),
XMID,bjbh
from tab_test

---------------------------------------------------------------

INSERT tab_mingxi (xh,XMID,bjbh)
SELECT xh=(select count(*) from tab_test where bjbh<= A.bjbh )
,XMID,bjbh from tab_test as A
---------------------------------------------------------------

SELECT IDENTITY(int, 1,1) AS ID_Num ,XMID,bjbh
INTO #NewTable
FROM tab_test b

insert into tab_mingxi
select * from #NewTable

如果原tab_mingxi 沒有數據，可以DROP 它
然後直接用tab_mingxi 代替上面的#NewTable即可

---------------------------------------------------------------

INSERT tab_mingxi (xh,XMID,bjbh)
SELECT xh=1+isnull((select count(*) from jianguan.dbo.tab_baojianmingxi where bjbh<a.bjbh ),0),XMID,bjbh from tab_test a