Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    INDIA
    Posts
    9

    Unanswered: Simple But Complex Problem

    HI FRIENDS,

    I HAVE ONE FOLLOWING TABLE

    CREATE TABLE1(
    COL1 VARCHAR(400))

    I INSERTED ONE ROW. NOW LENGTH OF COL1 IS 350 CHARACTER.

    WHEN I FIRED QUERY "SELECT COL1 FROM TABLE1"
    I GOT ONLY FIRST 256 CHARACTER.
    I WANT TO RETRERIVE FULL CONTENT OF "COL1" .
    PLS GUIDE ME , HOW SOLVE THIS PROBLEM.

    THANKING YOU,
    DHIRAJ

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    hi,
    go to tools>Options>Results
    update the Maximum characters per column to a higher value say 2000
    and apply.
    now u will be able to see the whole column.
    regards,
    harshal.

  3. #3
    Join Date
    Jan 2004
    Location
    INDIA
    Posts
    9
    Hi Harshal,

    Thanks for Attention.
    I tried to set option as you mension.
    But i unable find Results under Option menu command.
    I am using MS-SQL 7.0 verson.
    pls help me . what to do.

    Thanks again.
    With Best Regards,
    Dhiraj
    Last edited by DJSAKARIYA; 02-02-04 at 22:51.

Posting Permissions

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