Post reply

Too large to UPDATE ?

  • July 3, 2008 at 1:41 am

    #209490

    Column name : ExecSummary, VARCHAR(8000)

    UPDATE dbo.tblRegistration

    SET ExecSummary='

    extensive experience with IE,HTML & MS Office(Word,Excel,Powerpoint,Publisher) proficient in written, oral & interpersonal communication skills

    organized & dedicated with positive attitude

    multitasking with or without pressure thrive on working in a challenging

    environment can work individually and/or in a group effectively'

    WHERE emailaddress='mcloncion@gmail.com'

    But it could only show me :

    extensive experience with IE,HTML & MS Office(Word,Excel,Powerpoint,Publisher)

    proficient in written, oral & interpersonal communication skills

    organized & dedicated with positive attitude

    multitasking with or without pressure thrive on working in a cha

    This content is less than 8000 characters, why it failed ?

  • July 3, 2008 at 2:12 am

    #837649

    Are you viewing this in management studio? There's a setting (Tools -> Options, expand out query results, SQL Server) that says how much data is displayed in text or grid mode.

    Check the values of "Maximum number of characters displayed" under "results to Text" and "Maximum Characters Retrieved Non XML Data" under "Results To Grid"

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 3, 2008 at 2:30 am

    #837658

    Yes, it worked.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply