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
BEGIN PRINT 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
BEGIN PRINT space (@var) + replicate( '*' , @x) -- here space for
-- create spaces
SET @var = @var + 1 -- set
set @x = @x - 1 -- set
END -- End
|
Output :
***** **** *** ** *