sql server (microsoft): you need TOP 100% for a view

you can't use an order by in a view without a top 100%

are you using Access Data Projects??

YAYAYAYAYAYAY

Ever since we rebooted the machine, all of our views have been modified with
the "TOP 100%" We cannot seem to remove this. MS Access barks at us when we
try to modify a table and it's because of the TOP 100% text.

How to remove it...make it go away...just ignore it?

Cheers,

Rich

Modify the view definition in Query Analyzer.

--
David Portas
SQL Server MVP
--

[quoted text, click to view]

You don't need TOP 100% for views and you shouldn't use ORDER BY in views
either. Views are supposed to be unordered and with good reason. Queries
against the view may well perform better without an ORDER BY clause in the
view definition. The best place to use ORDER BY is when you query the view.

--
David Portas
SQL Server MVP
--

David

i'll keep order by and top 100% in views if and when i please.

Doing a sproc on top of a view is a waste of resources

Thanks

You are of course welcome to use views any way you wish. However, your
second statement is incorrect if you are referring to SQL Server resources.
Ordered views are likely to consume resources compared to unordered ones
unless you are talking about an atypical scenario where a view is used to
return the same unchanging result set every time it is used.

A stored procedure over a view will not waste resources. In fact
parameterized SPs help reduce query recompiles, which is one reason why we
use them.

--
David Portas
SQL Server MVP
--

[quoted text, click to view]

i think that sprocs are over-used and views are underused.

i use views... ALLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL
the friggin time with Analysis Services