/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

7 votes288 views1 answer
Sql server convert string to date
SQL
0 vote321 views1 answer
Mysql backup query
SQL
0 vote286 views1 answer
Mysql join same table multiple times group by
SQL
6 votes282 views2 answers
Sql display max value
SQL
0 vote291 views1 answer
Sql period overlap
SQL
0 vote335 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote292 views1 answer
How to see password mysql vestacp
SQL
0 vote322 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote279 views1 answer
Create or replace view postgress
SQL
4 votes249 views1 answer
Sql list users and roles
SQL