SQL 2000执行不正确。 [英] SQL 2000 execute not correct.

问题描述

我使用了链接服务器。 m_component有50k行。我在下面的脚本中查询数据。但我只收到了95条记录。我不明白为什么？每个人都帮助我。

I used linked server. m_component have 50k rows. I query data as script below. But I received only 95 records. I don't understand why ? Every one help me.

select ProductCode ,RevisionCode, ComponentCode
 ,1.0 /  ProductCount * MaterialLength  / floor(500.0 / MaterialWidth) / 1000.0  as Std
 from [x.x.x.x].[FPiCS-B03].[dbo].[m_Component]

===> 95条记录

===> 95 records

select ProductCode ,RevisionCode, ComponentCode
 from [x.x.x.x].[FPiCS-B03].[dbo].[m_Component]

==> 50k记录

==> 50k records

推荐答案

我明白了。因为遇到零除错误。

I understood it. Because divide by zero error encountered.

这篇关于SQL 2000执行不正确。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！