萬盛學電腦網

 萬盛學電腦網 >> 數據庫 >> mssql數據庫 >> SQLCE建復合索引

SQLCE建復合索引

   CREATE TABLE [PT_check3] ( [FCheckPlan_ID] NVARCHAR(20) NOT NULL , [FBarCode] NVARCHAR(20) NOT NULL, [FIn_Code] NVARCHAR(10) NOT NULL , [FGoodsName] NVARCHAR(30) NOT NULL , [FIsReCheck] INT NULL , [FQty] Numeric(10, 2) NULL , CONSTRAINT [PK_vw_Checks] UNIQUE ([FCheckPlan_ID],[FIn_Code]))

copyright © 萬盛學電腦網 all rights reserved