I have installed SQL Server 2017 on RHEL Linux 7.3 and I use the SQLCMD utility to query SQL Server.
When I try to query for example: 'SELECT * FROM SYS.DATABASES'. I get an exit like this:
How to format the output for SQL commands on SQLCMD for SQL Server under RHEL Linux?
For example, in Oracle, we use SET LINES 200 PAGES 200 & # 39; to format the output / width of the output columns.
NOTE: I have already tried the following solution (as in another answer on dba.stackexchange):
C: /> sqlcmd -S my_server
: setvar SQLCMDMAXVARTYPEWIDTH 30
: setvar SQLCMDMAXFIXEDTYPEWIDTH 30
SELECT * of my_table