Field does not show all of the data
Results 1 to 2 of 2

Thread: Field does not show all of the data

  1. #1
    Join Date
    Apr 2014
    Posts
    1

    Field does not show all of the data

    When I query the database only part of the returned information shows in the column. It is a test field. I know that there is 180 records but when I look at contents I only see 20 records and the last record I see is incomplete. When I pull the data and process it I will recover all 180 records. I would like to be able to copy and paste all 180 records. I assume that the amount of text that is viewable is limited. Not sure if I can control that.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,882
    If you use ssms, it displays 256 characters per text column by default. You can change it in query -> query options -> results -> text -> maximum number of characters displayed in each column.

Posting Permissions

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