数据库三角形小测试

数据库三角形算法##

DECLARE @RUMLIST  INT =25
DECLARE @SUMLIST  INT 
DECLARE @I  INT
SET @I=@RUMLIST;
WHILE(@RUMLIST>0)
BEGIN
DECLARE @NAME NVARCHAR(100)='';
    SET @SUMLIST=@RUMLIST+1
	WHILE(@SUMLIST>0)
	BEGIN
		SET @SUMLIST=@SUMLIST-1
		SET @NAME=@NAME+' '
	END
	SET @RUMLIST=@RUMLIST-1;
	DECLARE @RUN INT 
	SET @RUN=@I-@RUMLIST;
	DECLARE @AT NVARCHAR(100)='';
	WHILE(@RUN>0)
	BEGIN
		SET @AT=@AT+'*'+' '	
		SET @RUN=@RUN-1
		
	END
	PRINT @NAME+@AT
END