Print different star patterns in SQL
Last Updated :
21 Mar, 2018
Let’s see how we can print the pattern of various type using SQL.
Syntax :
Declare @variable_name DATATYPE -- first declare all the
-- variables with datatype
-- like (int)
select @variable = WITH_ANY_VALUE -- select the variable and
-- initialize with value
while CONDITION -- condition like @variable > 0
begin -- begin
print replicate('*', @variable) -- replicate insert the *
-- character in variable times
set increment/decrement -- in increment/decrement
-- @variable= @variable+1
END -- end while loop
First Pattern :
DECLARE @var int
SELECT @var = 5
WHILE @var > 0
BEGIN
PRINT replicate('* ', @var)
SET @var = @var - 1
END
|
Output :
* * * * *
* * * *
* * *
* *
*
Second Pattern :
DECLARE @var int
SELECT @var = 1
WHILE @var <= 5
BEGIN
PRINT replicate('* ', @var)
SET @var = @var + 1
END
|
Output :
*
* *
* * *
* * * *
* * * * *
Third Pattern :
DECLARE @var int, @x int
SELECT @var = 4,@x = 1
WHILE @x <=5
BEGIN
PRINT space(@var) + replicate('*', @x)
SET @var = @var - 1
set @x = @x + 1
END
|
Output :
*
**
***
****
*****
Fourth Pattern :
DECLARE @var int, @x int
SELECT @var = 0,@x = 5
WHILE @x > 0
BEGIN
PRINT space(@var) + replicate('*', @x)
SET @var = @var + 1
set @x = @x - 1
END
|
Output :
*****
****
***
**
*
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...