Post reply

see full data of type NTEXT.

  • April 24, 2008 at 3:06 am

    #71933

    I had one table Bug_post having Column bg_desc of type ntext.

    when i run query "select top 1 bg_desc from Bug_post" in query analyer.

    i m not able to see full data but only upto some length like

    bg_desc

    ------------------------------------------------------------------------------------------------------------------------------------------

    select isnull(pr_background_color,'#ffffff'), bg_id [id], bg_short_desc [desc], pj_name [project], ct_name [category],isnull(udf_name,'') [Attribute], rpt.us_username [reported by], bg_reported_date [reported on], pr_name [priority], asg.us_username [assi

    (1 row(s) affected)

    above data return by query is not complete.

    In Front End Data will display properly.

    then why i m able to see in query analyer.

  • April 24, 2008 at 7:48 am

    #806584

    If you check the options for Query Analyzer, you'll find that it has a maximum number of characters to display per column. There's a cap on that, but I don't remember what it is.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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