/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

1 vote334 views1 answer
Store select query result in variable sql server
SQL
1 vote306 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote318 views1 answer
How to order result of subquery in select
SQL
1 vote298 views1 answer
Input in mysql
SQL
0 vote346 views1 answer
Create table split string function in sql server
SQL
5 votes314 views2 answers
Get columns number sql
SQL
-1 vote340 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote312 views2 answers
How to get json data mysql
SQL
0 vote311 views1 answer
Php delete database
SQL
0 vote336 views1 answer
Migration graphql
SQL