#TSQL, (削除) 220 (削除ここまで) 148 bytes#
TSQL, (削除) 220 (削除ここまで) 148 bytes
#TSQL, (削除) 220 (削除ここまで) 148 bytes#
TSQL, (削除) 220 (削除ここまで) 148 bytes
TSQL, 220 bytes #TSQL, (削除) 220 (削除ここまで) 148 bytes#
Improvement posted by ZLK:
DECLARE @o@ VARCHAR(MAX)=''SELECT TOP 17 @o+=REPLACE17@+=REPLACE('1@2@3@4@5@6@7@8@9@0','@',REPLACE(REPLACE(CAST(POWERSPACE(10,ABS(ROW_NUMBER9-RANK()OVER(ORDER BY object_id)-9)+1)/10AS VARCHAR(MAX)),'0',' '),'1',''))+'
'FROM sys.objects PRINT @o@
TSQL, 220 bytes
DECLARE @o VARCHAR(MAX)=''SELECT TOP 17 @o+=REPLACE('1@2@3@4@5@6@7@8@9@0','@',REPLACE(REPLACE(CAST(POWER(10,ABS(ROW_NUMBER()OVER(ORDER BY object_id)-9)+1)/10AS VARCHAR(MAX)),'0',' '),'1',''))+'
'FROM sys.objects PRINT @o
#TSQL, (削除) 220 (削除ここまで) 148 bytes#
Improvement posted by ZLK:
DECLARE @ VARCHAR(MAX)=''SELECT TOP 17@+=REPLACE('1@2@3@4@5@6@7@8@9@0','@',SPACE(ABS(9-RANK()OVER(ORDER BY object_id))))+'
'FROM sys.objects PRINT @
TSQL, 220 bytes
DECLARE @o VARCHAR(MAX)=''SELECT TOP 17 @o+=REPLACE('1@2@3@4@5@6@7@8@9@0','@',REPLACE(REPLACE(CAST(POWER(10,ABS(ROW_NUMBER()OVER(ORDER BY object_id)-9)+1)/10AS VARCHAR(MAX)),'0',' '),'1',''))+'
'FROM sys.objects PRINT @o
Output:
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1234567890
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0
1 2 3 4 5 6 7 8 9 0