Print different star patterns in SQL
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 -- Declare SELECT @var = 5 -- Initialization WHILE @var > 0 -- condition BEGIN -- Begin PRINT replicate('* ', @var) -- Print SET @var = @var - 1 -- decrement END -- END |
Output :
* * * * * * * * * * * * * * *
Second Pattern :
DECLARE @var int -- Declare SELECT @var = 1 -- initialization WHILE @var <= 5 -- Condition BEGIN -- Begin PRINT replicate('* ', @var) -- Print SET @var = @var + 1 -- Set END -- end |
Output :
* * * * * * * * * * * * * * *
Third Pattern :
DECLARE @var int, @x int -- declare two variable SELECT @var = 4,@x = 1 -- initialization WHILE @x <=5 -- condition BEGINPRINT space(@var) + replicate('*', @x) -- here space for -- create spaces SET @var = @var - 1 -- set set @x = @x + 1 -- set END -- End |
Output :
* ** *** **** *****
Fourth Pattern :
DECLARE @var int, @x int -- declare two variable SELECT @var = 0,@x = 5 -- initialization WHILE @x > 0 -- condition BEGINPRINT space(@var) + replicate('*', @x) -- here space for -- create spaces SET @var = @var + 1 -- set set @x = @x - 1 -- set END -- End |
Output :
*****
****
***
**
*
