How can I set the maximum number of characters per column using sqlcmd?

Question

While using SQL Server Management Studio, I generally do:

Query->Query Options->Advanced->SET NOCOUNT
Query->Query Options->Text->Enter 8000 in the lower right box

Can someone please tell me if there is anyway I could do this using sqlcmd?

Answer 1

You have these switches for sqlcmd that affect width etc

• -w
• -Y
• -y