/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

0 vote177 views1 answer
Select multiple row from primary key sql
SQL
0 vote164 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote184 views1 answer
Mysql where sum > 0
SQL
0 vote184 views1 answer
Sql bild in function
SQL
4 votes177 views1 answer
Datepart postgres
SQL
0 vote187 views1 answer
Sql convert unix time to date
SQL
0 vote224 views1 answer
Query only first letter string
SQL
2 votes178 views1 answer
Scaffold npgsql net core
SQL
0 vote170 views1 answer
Sql server remove primary key without dropping table
SQL
3 votes184 views1 answer
Postgres kill running query
SQL