/SQL/Sqlcmd xml output insert line break after every 2033 characters

Sqlcmd xml output insert line break after every 2033 characters

-- Useless
select row_number() over(order by (select 1)) as rn
from sys.all_objects
for json auto

-- Useful
select (
  select row_number() over(order by (select 1)) as rn
  from sys.all_objects
  for json auto
)

Source: stackoverflow.com

Similar codes

9 votes113 views2 answers
Convert data type in sql
SQL
1 vote136 views3 answers
SELECT * FROM
SQL
0 vote147 views1 answer
Hierarchal database table
SQL
0 vote127 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote115 views1 answer
Mariadb mysql root access denied
SQL
0 vote113 views1 answer
Mysql show category once count how many products
SQL
0 vote113 views3 answers
Sql parenthetical expression examples
SQL
0 vote117 views1 answer
Sql server datetime
SQL
1 vote123 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
1 vote107 views2 answers
Difference between in and between in sql
SQL