/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

0 vote176 views1 answer
Tsql cte in a transaction
SQL
0 vote137 views1 answer
Sql server alter table column nullable
SQL
0 vote121 views1 answer
Duplicate foreign key constraint name
SQL
3 votes174 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote156 views1 answer
Nodejs sql get one to many relationship as array
SQL
4 votes131 views1 answer
Postgresql show current database
SQL
0 vote139 views2 answers
Sql join on comma separated field
SQL
1 vote197 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote132 views1 answer
Power bi find all ids not in other tables
SQL
3 votes164 views2 answers
Synonym oracle
SQL