/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 vote269 views1 answer
Why do we need data structure in sql
SQL
10 votes143 views2 answers
Show tables in schema oracle
SQL
0 vote128 views1 answer
Oracle index hint multiple tables example
SQL
0 vote228 views3 answers
Osx stop mysql service
SQL
0 vote146 views1 answer
Mariadb create index if not exists
SQL
0 vote135 views1 answer
Sql server order by nulls last
SQL
0 vote129 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
2 votes180 views1 answer
Creating a view SQL
SQL
-2 votes188 views1 answer
Trunc in sql
SQL
2 votes142 views4 answers
Mysql get all tables row count
SQL