2020-12-08 16.01.sql 727 B

12345678910111213141516171819202122232425
  1. USE befri_Goldhoo
  2. GO
  3. INSERT dbo.ValueTextMap
  4. ( TableName ,
  5. FieldName ,
  6. Value ,
  7. Text ,
  8. DisplayOrder ,
  9. Opened
  10. )
  11. VALUES ( 'basedata.Inventory' , -- TableName - varchar(50)
  12. 'ProductionProperty' , -- FieldName - varchar(50)
  13. 1 , -- Value - int
  14. N'¿â´æÉú²ú' , -- Text - nvarchar(100)
  15. 1 , -- DisplayOrder - tinyint
  16. 1 -- Opened - bit
  17. ),
  18. ( 'basedata.Inventory' , -- TableName - varchar(50)
  19. 'ProductionProperty' , -- FieldName - varchar(50)
  20. 2 , -- Value - int
  21. N'¿É¶¨ÖÆÉú²ú' , -- Text - nvarchar(100)
  22. 2 , -- DisplayOrder - tinyint
  23. 1 -- Opened - bit
  24. );