Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Unanswered: Problem SQL select statement

    Hi,

    I have a table called "company" which has 12000 rows. I executed a SQL select statement from the Query Analyzer to display the table.

    select * from company.

    Its displaying all the rows in the table. But the Query is not getting completed. It still shows the RED mark and "Executing Query Batch".
    When I use this SQL query from my application. My application hangs.
    Can anybody help me in this.
    Its very urgent.
    Regards
    Neeraja
    Neeraja

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Which version of sql server are you using ? Do you have any indexes on the table ?

  3. #3
    Join Date
    Aug 2002
    Location
    Kampala, Uganda - East Africa
    Posts
    13
    SET PAGESIZE 13000

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •