iT邦幫忙

0

sql COLLATE Chinese_Taiwan_Stroke_CI_AS不要秀出來

choyi 2008-12-10 14:32:1110237 瀏覽

之前我用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]

jsperng iT邦研究生 1 級 ‧ 2008-12-11 10:20:23 檢舉

1 個回答

14
jsperng
iT邦研究生 1 級 ‧ 2008-12-11 10:10:40
最佳解答

Microsoft SQL Server Management工具-選項,再點選左側指令碼,右側展開資料表和檢視選項,找到包含定序,將它設為 False即可。

我要發表回答

立即登入回答