Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lardmonster

    using a view on a different server

    OpenRowSet also works with SQL Server 7.0, as far as I remember :-) -- lardmonster - an occasional visitor mkflint@hotmail.com
  2. lardmonster

    Limiting returned rows

    I suppose it is a lot of work, but I guess that's the trade-off with writing code that is implementation-independent. For example, the select ... top n directive is only valid for MS SQL version >=7.0 -- lardmonster - an occasional visitor mkflint@hotmail.com
  3. lardmonster

    Limiting returned rows

    SET ROWCOUNT 10 Not very standard SQL either... OK, lets think about this: you want a set of data - let's say something like: select c.co_name from company c order by c.co_name asc now lets add another column to get a row-count: select c.co_name, (select count(*) from company c2...

Part and Inventory Search

Back
Top