为什么我的视图被自动添加代码
SELECT TOP 100 PERCENT dbo.vAdWordInfo.*, ArcPD.maxnum(KeyPrice, SiteTypePrice,
AreaPrice) AS CurrPrice
FROM dbo.vAdWordInfo
ORDER BY CurrPrice DESC

我在视图里输入的语句是
SELECT dbo.vAdWordInfo.*, ArcPD.maxnum(KeyPrice, SiteTypePrice,
AreaPrice) AS CurrPrice
FROM dbo.vAdWordInfo
ORDER BY CurrPrice DESC
怎么被自动添加TOP代码呢是怎么回事
maxnum是一个用户定义函数，用来返回三个值中最大值



[解决办法]
系统自动优化的结果
[解决办法]
企业管理器就会这样查询分析器就不会这样