/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 vote158 views1 answer
Hangfire clear all jobs
SQL
4 votes122 views2 answers
Tsql utf to local time
SQL
1 vote115 views1 answer
Firebase bigquery cloud message
SQL
8 votes122 views3 answers
Mysql alter table add index
SQL
0 vote127 views1 answer
Get week day name sql server
SQL
0 vote149 views1 answer
Selecting all columns from table sql database
SQL
5 votes121 views1 answer
Sqlite alter table add column
SQL
0 vote128 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote138 views2 answers
How covert into int in maria db
SQL
0 vote89 views1 answer
How to fetch highest score in minimum time using mysql
SQL