想问一下这两个题用SQL 语言怎么写，

DECLARE @a smallint,@b smallint,@str varchar(1000)
set @a=1
WHILE @a<=10
BEGIN    
SET @b=1    
SET @str=''    
WHILE @b<=@a    
BEGIN
SELECT @str=@str+'*'       
SET @b=@b+1    
END    
PRINT @str    
SET @a=@a+1 
END