/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 vote287 views1 answer
Create function syntax sql server
SQL
0 vote289 views1 answer
Sql beginning of previous month
SQL
0 vote341 views1 answer
Min varias colunas spark sql
SQL
0 vote305 views1 answer
Get date ISO in psql
SQL
1 vote301 views1 answer
Oracle stop
SQL
0 vote277 views1 answer
Create api project in visual studio 2019 and sql server
SQL
2 votes289 views1 answer
Sql server find table name
SQL
0 vote285 views1 answer
Postgresql array to rows
SQL
3 votes284 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote306 views1 answer
Sql server epoch to datetime
SQL