Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Location
    Indian Head, MD
    Posts
    30

    Question Unanswered: Maximum length of return in Query Analyzer

    I am executing a SELECT statement that has about 500 characters of literal characters concatenated with the contents of a field from a table. I am then storing the result to be run as dynamic SQL. I am finding that when run this as select statement in query analyzer, the last part of the literal gets truncated. When I run it as a cursor and store it in a varchar(1000) variable and print the variable everything works fine. In addition when I put the select statement in a stored procedure and return this to a ADO recordset, the resultset is fine as well. But running the stored procedure in query analyzer truncates the results as well. The issue seems to be getting the results of the SELECT in query analyzer. Even running the stored procedure in the SQL area of Enterprise Manager returns a proper result. Has anyone heard of a maximum return from a select in query analyzer?

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    Yes, check out: Tools, Options, the Results-tab. "Maximum characters per column".

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, and I should probably post a FAQ entry for it.

    1. Shift-Ctrl-o for options
    2. Click the Results tab
    3. Near the middle, Maximum characters per column..

    -PatP

  4. #4
    Join Date
    Feb 2003
    Location
    Indian Head, MD
    Posts
    30
    Manj Tak
    Danke Sha
    merci beaucoup
    mucho gracias

  5. #5
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by Pat Phelan
    Yes, and I should probably post a FAQ entry for it.

    -PatP
    Can you put one on there for making DBA coffee?

    1. 4 heaping tbsp coffee grounds/8oz water
    2. Pinch of salt
    3. Add water tapped from boiler/radiator
    4. Brew in pot that's never been washed using yesterday's filter
    5. Serve in cup that's never been washed

    Thanks,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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