資料表新增bit欄位且有預設值
ALTER TABLE Pro_Type ADD [TR] BIT
GO
ALTER TABLE [dbo].[Pro_Type] ADD CONSTRAINT [DF_Pro_Type_TR] DEFAULT ((0)) FOR [TR]
GO
update Pro_Type set [TR] = 0 where [TR] is null
GO
ALTER TABLE Pro_Type ALTER COLUMN [TR] bit NOT NULL
GO
