下面的是簇索引,不会改变你得顺序:
CREATE TABLE #rsccategory
(categoryid NUMERIC(2) IDENTITY(1,1),
categoryname VARCHAR(20) NOT NULL UNIQUE clustered,
PRIMARY KEY(categoryid)
)insert #rsccategory select 'url' union all select 'document' union all select 'book' union all select 'software' union all select 'casus' union all select 'project' union all select 'disert'select * from #rsccategory非簇索引:CREATE TABLE #rsccategory
(categoryid NUMERIC(2) IDENTITY(1,1),
categoryname VARCHAR(20) NOT NULL,
PRIMARY KEY(categoryid)
)create index xx on #rsccategory(categoryname)insert #rsccategory select 'url' union all select 'document' union all select 'book' union all select 'software' union all select 'casus' union all select 'project' union all select 'disert'select * from #rsccategorygo
drop table #rsccategory
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货