• February 14

    Select Query: Retrieve Fixed Number of Rows Part 2

    Posted Under: Tags: SQL

    In my last entry, I touched on a way to dynamically select a specific number of rows from a table in a SELECT SQL query. It works great if you are going to supply the value directly when you call the procedure. But what if you are using a static value that is stored in the database itself? I have a Settings table that stores Property/Value pairs, and one of those properties is the NumItems that I want to retrieve from the SELECT query!

    I could create a public shared property that will retreive the value from the database, ...

    Read More »

  • February 13

    Select Query: Retrieve Fixed Number of Rows

    Posted Under: Database Development Tags: SQL

    As I'm beginning work on my senior project, I have discovered the need to select a specific number of rows from a SELECT query in SQL Server 2000. Although the new 2005 version has the built in ability to pass a variable for the TOP clause, no such functionality exists in SQL SERVER 2000. Fortunately I found a great resource showing various ways to accomplish it. The best one in my opinion is to pass the variable into the SET ROWCOUNT command, which can take a variable as a value:

     


    CREATE PROCEDURE dbo.getFoo
    @top INT
    AS
    BEGIN
    SET ROWCOUNT ...

    Read More »