etl的表输入时精度问题

SELECT
RecipeID
, IngredientID as ingre_id
, ROUND(Quantity, 5) Quantity
, Preparation
, RecipeIngredientID
, Validated
, fd_Type
, UnitOfUseID
, OriginalQuantity
, 2Preparation
, CookingType
, 2CookingType
, PreviousIngredientID
FROM recipeingredients
where RecipeID =?

posted @ 2018-04-01 10:37  baby孔祥超  阅读(122)  评论(0编辑  收藏  举报