-
SQL wrapping issue
I just switched from Windows 95 to Windows NT. Now when I query a SQL Server
table in either ISQL or SQL Programmer, if there are more than a certain
number of columns in the table and I do a 'Select * from...' the latter columns
wrap and display over the first columns, making them unreadable. Any ideas
on on how to fix this???
-
Re: SQL wrapping issue
Get a really, really large monitor and set the resolution to very small
letters. Actually, it has been my experience where the result comes up with
a scroll bar to allow you to scroll left and right (or vice versa). Check
your configuration in Query, Options, Format Options of Isql/w. Column
aligned is the default. If you have something else, this may be the
problem.
"Joe Olsen" <jolsen@saionline.com> wrote in message
news:38e4bdbe@news.devx.com...
>
> I just switched from Windows 95 to Windows NT. Now when I query a SQL
Server
> table in either ISQL or SQL Programmer, if there are more than a certain
> number of columns in the table and I do a 'Select * from...' the latter
columns
> wrap and display over the first columns, making them unreadable. Any
ideas
> on on how to fix this???
-
Re: SQL wrapping issue
I use SQL Programmer all the time and don't have this problem. I use it from
NT, Win 2K, and 95. Are you having the problem when you print or when you
view on the screen? If your data has embedded line returns it could cause
some interesting results.
"C. E. Buttles" <cebuttle@sprintsvc.net> wrote:
>Get a really, really large monitor and set the resolution to very small
>letters. Actually, it has been my experience where the result comes up
with
>a scroll bar to allow you to scroll left and right (or vice versa). Check
>your configuration in Query, Options, Format Options of Isql/w. Column
>aligned is the default. If you have something else, this may be the
>problem.
>
>
>"Joe Olsen" <jolsen@saionline.com> wrote in message
>news:38e4bdbe@news.devx.com...
>>
>> I just switched from Windows 95 to Windows NT. Now when I query a SQL
>Server
>> table in either ISQL or SQL Programmer, if there are more than a certain
>> number of columns in the table and I do a 'Select * from...' the latter
>columns
>> wrap and display over the first columns, making them unreadable. Any
>ideas
>> on on how to fix this???
>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks