Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
doco
Yak Posting Veteran
77 Posts |
 Posted - 2009-07-21 : 22:10:58
|
| I am wondering why when querying a field of type varchar(max) with approximately 70 lines and no more than 65 chars wide per line from a text file, will only produce the first 6 lines.I have checked the insert value and all 70 lines are there. I have also queried on those fields filtering by data that I know is in the last few lines of the field and I get returns but only the first few lines. It is there it just won't print out...Why?Education is what you have after you've forgotten everything you learned in school |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-21 : 22:33:22
|
| what are you using to query it? i see everything in mine |
 |
|
|
doco
Yak Posting Veteran
77 Posts |
Posted - 2009-07-21 : 22:41:50
|
I ask for that field ( history ) filtered by another field in the same table.select history from poker_hands..tourney_holdem_hand_history where id_hand = '39067632-8' producesquote:
history---------------------------------------------------------------Hand #39067632-8 at SnG-0453036 (No Limit Holdem Sit and Go)Started at 18/May/09 19:11:23 rossirine is at seat 1 with 1990. madmarine is at seat 2 with 1160. biker mike is at seat 5 with 970. kalcali2 is at seat 6 with 950.
which is about 10% if what is thereEducation is what you have after you've forgotten everything you learned in school |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-22 : 01:46:21
|
| in SSMS go to TOOLS OPTIONS, expand Query Results, SQL Server, Results to Grid.change the maximum characters retrieved |
|
|
|
doco
Yak Posting Veteran
77 Posts |
Posted - 2009-07-22 : 03:12:37
|
| Thanks Russell. Max characters per column for text is 8192. Which is more than sufficient for current use.Education is what you have after you've forgotten everything you learned in school |
|
|
|
|
|
|
PRINT OUT ALL OF VARCHAR(MAX) FIELD