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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-06 : 08:20:37
|
| Mayur writes "How can i get the same result for both Statement ?(1). Print '[Account_ID], [AccountType], [IndividualOrCompany_ID], [IsHouseAccount], [Balance?], [Employee_ID_CreatedBy], [DateOpened], [UpdateDate], [DisplayAccount_ID], [Active], [TaxExemptID], [UnappliedCreditAmount], [AccountTimeStamp], [LastOrderGroupPaymentDetail_ID], [AccountPaymentDetail_ID], [AllowEmailMktg]'(2). Select '[Account_ID], [AccountType], [IndividualOrCompany_ID], [IsHouseAccount], [Balance?], [Employee_ID_CreatedBy], [DateOpened], [UpdateDate], [DisplayAccount_ID], [Active], [TaxExemptID], [UnappliedCreditAmount], [AccountTimeStamp], [LastOrderGroupPaymentDetail_ID], [AccountPaymentDetail_ID], [AllowEmailMktg]'Select Statement(2nd Case) Truncate the literal string. How can i get the same as print Statement ?" |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-05-06 : 08:23:11
|
| It is not truncating it. That is a display thing. Open Query Analyzer, Tools, Options, Results tab. Change the Maximum characters per column to a larger value. |
 |
|
|
|
|
|
|
|
Problem with Select Statement