三元财务API

sql_20190428.sql 916B

1234567
  1. /****** Script for SelectTopNRows command from SSMS ******/
  2. SELECT *
  3. FROM [CallCenter_SanYuanCW].[dbo].[T_Wo_WorkOrderItem]
  4. where [type]=1 --and [state]=1
  5. -- alter table T_Wo_WorkOrderItem add IsUsed int default(0)
  6. -- EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否在用,0是 1否' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_WorkOrderItem', @level2type=N'COLUMN',@level2name=N'IsUsed'
  7. --GO