/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 vote288 views2 answers
Sql server backup table
SQL
31 votes256 views1 answer
Postgresql add column with constraint
SQL
0 vote291 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote266 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote291 views1 answer
Make parameters nullable in sql server
SQL
0 vote258 views2 answers
Install phoenix
SQL
16 votes271 views2 answers
Add column to all tables after first column mysql
SQL
5 votes304 views2 answers
Functions
SQL
0 vote248 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote261 views3 answers
Sql delete all except
SQL