Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    50

    Unanswered: result of query so large?

    Hi all,
    i have a problem ...
    if there is a query that returns so many rows. I want to know where the result is stored? for example:what database?, what table?, what transaction log file?
    Thanks fr reading.

  2. #2
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58

    Talking

    if you want to restrict the nos of output, try using pagesize and rowcount parameters in ur query script.

    Deepak K
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  3. #3
    Join Date
    Jan 2004
    Posts
    50
    Originally posted by deepakontheweb
    if you want to restrict the nos of output, try using pagesize and rowcount parameters in ur query script.

    Deepak K
    sorry, i don not understan what ur way.
    please,

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Well ... from your posts it looks like you are trying to learn about SQL Server ...

    Dont mean to sound rude .. but I suggest you get a copy of the Holy Book (SQL Server Books Online ). This is the link

    http://www.microsoft.com/sql/techinf...2000/books.asp


    Also try to get some good books on Sql Server .. eg

    http://www.amazon.com/exec/obidos/tg...glance&s=books

    http://www.amazon.com/exec/obidos/tg...glance&s=books

    http://www.amazon.com/exec/obidos/tg...glance&s=books
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

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