/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

4 votes357 views1 answer
Oracle error line
SQL
1 vote424 views1 answer
STOP message of how many rows affected sql
SQL
0 vote352 views7 answers
Les jointures sql server
SQL
6 votes349 views1 answer
Wordpress change user password sql
SQL
2 votes372 views1 answer
Cast string to datetime mysql
SQL
1 vote333 views1 answer
How to print longest name in sql
SQL
0 vote394 views1 answer
Use mysql in java program
SQL
0 vote347 views2 answers
SQL BULK INSERT
SQL
1 vote340 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote412 views1 answer
Sql alternative to max statement
SQL