新野县12345_后端

工单添加字段.sql 914B

12345678910111213
  1. --ALTER TABLE T_Bus_WorkOrder ADD [F_DemandsTypeID] VARCHAR(200) NULL
  2. --EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'咂А煦濬id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Bus_WorkOrder', @level2type=N'COLUMN',@level2name=N'F_DemandsTypeID'
  3. --GO
  4. ALTER TABLE T_Bus_WorkOrder ADD [F_ComplainedUnitID] INT DEFAULT(0)
  5. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'掩芘咂等弇id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Bus_WorkOrder', @level2type=N'COLUMN',@level2name=N'F_ComplainedUnitID'
  6. GO
  7. ALTER TABLE T_Bus_WorkOrder ADD [F_AddressCodes] VARCHAR(50) NULL
  8. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'華硊ㄗ吽庈瓮盺ㄘ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Bus_WorkOrder', @level2type=N'COLUMN',@level2name=N'F_AddressCodes'
  9. GO