/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

11 votes176 views2 answers
Import sql file laravel cmd
SQL
1 vote149 views1 answer
Postgresql define pk sequence next number
SQL
0 vote164 views1 answer
Get created time of database psql 8
SQL
0 vote165 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote134 views1 answer
Distinct data types in a table sql query
SQL
0 vote145 views1 answer
Mysql create table like
SQL
1 vote137 views2 answers
Mysql filter by date mount
SQL
1 vote163 views1 answer
Load mysql dumb
SQL
4 votes138 views4 answers
What is primary key
SQL
0 vote151 views3 answers
Sql server import json
SQL