MySQL \G equivalent in SQL Server

Question

How does one format wide listings vertically like in MySQL using the sqlcmd client? Or should I be using osql instead?

And must I write "GO" each time to execute my query? Is there a shorthand?

Answer 1

You can use -y or -Y to limit the width of wide columns in SQLCMD, but I'm not sure there's a way to wrap the contents of the column within that width, which is what I believe you're asking.

Also, you can use -c to specify a custom command terminator instead of GO, which is the default.

Answer 2

You can use -y or -Y to limit the width of wide columns in SQLCMD, but I'm not sure there's a way to wrap the contents of the column within that width, which is what I believe you're asking.

Also, you can use -c to specify a custom command terminator instead of GO, which is the default.