Re: Is there a limit of 256 on CHAR data?
From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 05/13/04
- Next message: Aaron Bertrand - MVP: "Re: Is there a limit of 256 on CHAR data?"
- Previous message: Geoff N. Hiten: "Re: Is there a limit of 256 on CHAR data?"
- In reply to: Steve Z: "Is there a limit of 256 on CHAR data?"
- Next in thread: Steve Z: "Re: Is there a limit of 256 on CHAR data?"
- Reply: Steve Z: "Re: Is there a limit of 256 on CHAR data?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 May 2004 23:40:17 +0530
Steve,
Change the max number in Query analyzer 'tools' menu |options|'results' tab.
-- Dinesh SQL Server MVP -- -- SQL Server FAQ at http://www.tkdinesh.com "Steve Z" <szlamany@antarescomputing_no_spam.com> wrote in message news:Om8MaQROEHA.2468@TK2MSFTNGP11.phx.gbl... > We are creating some VIEWS that concatenate columns for output to FIXED > LENGTH TEXT FILES - with FIXED LENGTH columns. > > This is being done for various transmissions - W2 files to the SS Admin, > 1099 files to the IRS, eligibility files to various health organizations. > > While testing today, in Query Analyzer, it appeared that saying something > like: > > Cast( Cast(col1 as char(10))+Cast(Col2 as char(15))...+Cast(Colnn as > char(10)) as char(280)) > > The 280 was not liked. In QA we could only see a single column of I'm > thinking around 256 bytes? > > Does QA have a max size for column display in the grid? > >
- Next message: Aaron Bertrand - MVP: "Re: Is there a limit of 256 on CHAR data?"
- Previous message: Geoff N. Hiten: "Re: Is there a limit of 256 on CHAR data?"
- In reply to: Steve Z: "Is there a limit of 256 on CHAR data?"
- Next in thread: Steve Z: "Re: Is there a limit of 256 on CHAR data?"
- Reply: Steve Z: "Re: Is there a limit of 256 on CHAR data?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
