/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

12 votes358 views4 answers
Mysql version
SQL
0 vote347 views1 answer
Mysql command line ubuntu
SQL
5 votes381 views1 answer
How to get all table names in sql query
SQL
0 vote360 views1 answer
Postgresql heritage
SQL
65 votes587 views6 answers
Sql add column to table
SQL
0 vote355 views1 answer
Postgres truncate with cascade
SQL
0 vote373 views1 answer
Template MySQL Zabbix agent
SQL
0 vote359 views1 answer
Less than and between in sql query
SQL
0 vote383 views1 answer
Mysql 8 geo to json
SQL
0 vote420 views1 answer
Insert into using contant values and source table columns with sql
SQL