/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 vote360 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote326 views1 answer
UNION ALL LEFT JOIN
SQL
11 votes339 views2 answers
You are using safe update mode
SQL
0 vote323 views1 answer
Limiting query result using where in sql
SQL
10 votes385 views6 answers
Mysql set root password
SQL
0 vote349 views1 answer
Sql remove non numeric characters
SQL
0 vote284 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote344 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote326 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote322 views2 answers
Sql join on comma separated field
SQL