SELECT TOP 1000 [BinID]
,[Volume]
,[Weight]
,[Temp]
,[Hum]
,[DateTime]
,[Algorithm]
,[PrintNum]
,[Quality]=(case [Quality]
when 0 then '未评测'
when 1 then '数据可靠'
when 2 then '数据不一定可靠'
else '数据不可靠'
end)
,[BackData]
,[MiDu]
FROM [Factory].[dbo].[bindata]
where BinID = 3
SELECT TOP 1000 [BinID]
,[Volume]
,[Weight]
,[Temp]
,[Hum]
,[DateTime]
,[Algorithm]
,[PrintNum]
,[Quality]
,[BackData]
,[MiDu]
FROM [Factory].[dbo].[bindata]
where BinID = 3