sqlserver 批量更新表中的值 把某个字段更新成另外一个表的某个字段
UPDATE dbo.by_product SET weight=dbo.by_category.weight FROM dbo.by_category
JOIN dbo.by_product ON dbo.by_category.by_category_id=dbo.by_product.by_category_id
UPDATE dbo.by_product SET weight=dbo.by_category.weight FROM dbo.by_category
JOIN dbo.by_product ON dbo.by_category.by_category_id=dbo.by_product.by_category_id