之前我用sql server2005在編寫資料表指令碼時都不會出現COLLATE Chinese_Taiwan_Stroke_CI_AS
後來電重灌後只要是nvarchar的欄位都會出現COLLATE Chinese_Taiwan_Stroke_CI_AS 可以把它隱藏不要秀出來嗎??要去哪邊設定??
現在情況如下:
CREATE TABLE [dbo].[FDASA_010F](
[RID] [int] IDENTITY(1,1) NOT NULL,
[YY] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[FDSNO] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[ENO] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[ENAME] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[TITLE] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[LEV] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[NUM] [decimal](10, 0) NULL,
[CID] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[ADDRESS] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PSORT] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[VERIFYID] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[VEIFYDATE] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EDITID] nvarchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EDITDATE] varchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EDITTime] varchar COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]