/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 votes214 views3 answers
Create table in microsoft sql server
SQL
0 vote221 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote163 views1 answer
Mysql collation for all languages
SQL
2 votes219 views1 answer
Removing view
SQL
-2 votes204 views1 answer
How to open database
SQL
0 vote194 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote218 views2 answers
Oracle create tablespace autoextend
SQL
0 vote215 views1 answer
Console output pl sql
SQL
0 vote217 views1 answer
Sql count matching group by
SQL
1 vote200 views1 answer
Mysql average of multiple columns
SQL