try:create clustered index index_name on mybestTable(possibility)
我是liu(qq450639486): 你在两表上建聚集索引: CREATE CLUSTERED INDEX mybestTable_index ON mybestTable(possibility desc) ALTER TABLE possibility ADD id_num int IDENTITY(1,1)------------------------------------------------------------ CREATE CLUSTERED INDEX myworseTable_index ON myworseTable(possibility asc) ALTER TABLE possibility ADD id_num int IDENTITY(1,1)试一试,应该能行。
我是liu(qq450639486): 我上面的表名错了,这一个是对的。 你在两表上建聚集索引: CREATE CLUSTERED INDEX mybestTable_index ON mybestTable(possibility desc) ALTER TABLE mybestTable ADD id_num int IDENTITY(1,1)------------------------------------------------------------ CREATE CLUSTERED INDEX myworseTable_index ON myworseTable(possibility asc) ALTER TABLE myworseTable ADD id_num int IDENTITY(1,1)试一试,应该能行。
我确实也比较郁闷,但真的这个地方就是要排序。请您帮我看看,这种情况到底是怎么回事呢?不会是SQL SEVER2000的BUG吧?!
select top 10 * into #a from customers
order by contacttitleALTER TABLE #a ADD id_num int IDENTITY(1,1)customers表是northwind里面的。
你在两表上建聚集索引:
CREATE CLUSTERED INDEX mybestTable_index
ON mybestTable(possibility desc) ALTER TABLE possibility ADD id_num int IDENTITY(1,1)------------------------------------------------------------
CREATE CLUSTERED INDEX myworseTable_index
ON myworseTable(possibility asc) ALTER TABLE possibility ADD id_num int IDENTITY(1,1)试一试,应该能行。
我上面的表名错了,这一个是对的。
你在两表上建聚集索引:
CREATE CLUSTERED INDEX mybestTable_index
ON mybestTable(possibility desc) ALTER TABLE mybestTable ADD id_num int IDENTITY(1,1)------------------------------------------------------------
CREATE CLUSTERED INDEX myworseTable_index
ON myworseTable(possibility asc) ALTER TABLE myworseTable ADD id_num int IDENTITY(1,1)试一试,应该能行。