在一个表上创建非聚集索引和聚集索引

CREATE TABLE [dbo].[Change_STOCK_D](

[Change_STOCK_BI] [char](8)  NOT NULL,

[AID] [char](8)  NOT NULL,

[BARCODE] [char](18)  NULL,

[Q] [decimal](13, 4) NULL,

[BALE_Q] [decimal](13, 4) NULL,

[ENTRY_PRICE] [decimal](13, 4) NULL,

[TAX_ENTRY_PRICE] [decimal](13, 4) NULL,

[RETAIL_PRICE] [decimal](9, 2) NULL,

[ENTRY_PRICE_A] [decimal](13, 4) NULL,

[TAX_A] [decimal](13, 4) NULL,

[TAX_RETAIL_A] [decimal](13, 4) NULL,

[MEMO] [varchar](50)  NULL,

primary key nonclustered(change_stock_bi,aid)

)

go

create clustered index cidx_Change_STOCK_D on Change_STOCK_D(change_stock_bi)

go

转载于:https://www.cnblogs.com/kuailewangzi1212/archive/2012/07/02/2573273.html