/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 vote224 views1 answer
Psql connections
SQL
0 vote236 views2 answers
Script all indexes in a database
SQL
0 vote249 views2 answers
How to count codition
SQL
20 votes240 views3 answers
Update values in select statement sql
SQL
0 vote248 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote245 views1 answer
What is database username and password in mysqliconnect
SQL
3 votes223 views5 answers
Mysql get last inserted id
SQL
1 vote255 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote226 views1 answer
Equi joins in oracle
SQL
1 vote240 views1 answer
Top 10 rows in mysql
SQL