Wednesday, May 9, 2018

SQL: 對table新增一個欄位並設定預設值

ALTER TABLE ptMapper ADD remark NVARCHAR(200)
ALTER TABLE ptMapper ADD CONSTRAINT DF_ptMapper_remark DEFAULT ('') FOR remark

No comments: