/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

3 votes165 views2 answers
Sql paging query
SQL
0 vote172 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote214 views2 answers
Dbms interview questions
SQL
1 vote187 views2 answers
Rebuild index sql server
SQL
0 vote185 views1 answer
Distance calculator from lat long sql query
SQL
1 vote177 views2 answers
Mysql update LAST_INSERT_ID()
SQL
1 vote168 views3 answers
String to int mysql
SQL
6 votes209 views5 answers
Oracle list tablespaces
SQL
13 votes250 views4 answers
Mysql remove foreign key constraint
SQL
0 vote162 views1 answer
How to Remove milliseconds from Date time
SQL