答案

我们可以设置每列的宽度.

Answer

We can set the width of each column.

C:/> sqlcmd -S my_server

> :setvar SQLCMDMAXVARTYPEWIDTH 30
> :setvar SQLCMDMAXFIXEDTYPEWIDTH 30
> SELECT * from my_table
> go

我们也可以这样设置:sqlcmd -S my_server -y 30 -Y 30.

We can also set it like this: sqlcmd -S my_server -y 30 -Y 30.

SQLCMDMAXVARTYPEWIDTH (-y)

SQLCMDMAXVARTYPEWIDTH (-y)

它限制为大可变长度数据类型返回的字符数

It limits the number of characters that are returned for the large variable length data type

SQLCMDMAXFIXEDTYPEWIDTH (-Y)

SQLCMDMAXFIXEDTYPEWIDTH (-Y)

限制为以下数据类型返回的字符数

Limits the number of characters that are returned for the following data types

注意:设置 -y 对性能有严重影响.

Note: setting -y has serious performance implications.

参见 https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility