📙
Memo
  • 📋伯乐系列软件文档
  • 🚀开始
  • 👀常见问题处理
    • 🧬URT常见问题
    • #️⃣UC常见问题
    • 📈QCBox常见问题
  • 🖥️软件安装步骤
    • 💻新客户软件安装流程
    • 📦URT安装
    • 📑UC安装
    • 🔥小火把
    • 🗳️QcBOX
    • 📝质控报告
  • ⌨️常用SQL语句
    • 📊SqlDbx使用方法
    • 🧪SQL更新实验室号
    • ❄️SQL查询项目信息
    • 🏷️SQL更新URT单位
    • ⚠️SQL查询失控项目
    • 📅Sql Server日期格式转换
  • 📥常用网站及工具
    • ♻️空QCDAO数据库
    • 📁CHFS文件共享
  • 产品手册
    • 💡伯乐质控产品目录
由 GitBook 提供支持
在本页

这有帮助吗？

最后更新于3年前

目前在更新codelist后，会使urt部分单位出现乱码，解决方法如下，使用下列SQL语句，更新Unit表

其中有问题的单位 UnitID：3,4,13,20,21,22,23,32,33,53,61,63,68,69,73,80,109,124,125,157

SQL语句

上一页❄️SQL查询项目信息下一页⚠️SQL查询失控项目
  1. ⌨️常用SQL语句

🏷️SQL更新URT单位

解决部分单位乱码问题

UPDATE [dbo].[Unit] SET [Name] = N'µg/mL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 3;
UPDATE [dbo].[Unit] SET [Name] = N'µEq/mL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 4;

UPDATE [dbo].[Unit] SET [Name] = N'µg/dL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 13;

UPDATE [dbo].[Unit] SET [Name] = N'M/µL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 20;
UPDATE [dbo].[Unit] SET [Name] = N'K/µL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 21;
UPDATE [dbo].[Unit] SET [Name] = N'per µL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 22;
UPDATE [dbo].[Unit] SET [Name] = N'fL (cubic µm)', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 23;

UPDATE [dbo].[Unit] SET [Name] = N'PPM (µg/g, mg/kg)', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 32;
UPDATE [dbo].[Unit] SET [Name] = N'µIU/mL', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 33;

UPDATE [dbo].[Unit] SET [Name] = N'µmol/L', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 53;

UPDATE [dbo].[Unit] SET [Name] = N'PPB (ng/g, µg/kg)', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 61;

UPDATE [dbo].[Unit] SET [Name] = N'µg/L', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 63;

UPDATE [dbo].[Unit] SET [Name] = N'µmol/mol', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 68;
UPDATE [dbo].[Unit] SET [Name] = N'µmol/L/sec', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 69;

UPDATE [dbo].[Unit] SET [Name] = N'µg/L/hr', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 73;

UPDATE [dbo].[Unit] SET [Name] = N'µkat/L', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 80;

UPDATE [dbo].[Unit] SET [Name] = N'µmol/Ejaculate', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 109;

UPDATE [dbo].[Unit] SET [Name] = N'copies/µL', [Flag] = N'' WHERE [LanguageID] = 1 AND [UnitID] = 124;
UPDATE [dbo].[Unit] SET [Name] = N'µmol/mL', [Flag] = N'' WHERE [LanguageID] = 1 AND [UnitID] = 125;

UPDATE [dbo].[Unit] SET [Name] = N'μU/mL', [Flag] = N'RE' WHERE [LanguageID] = 1 AND [UnitID] = 157;