Veamos cómo podemos imprimir el patrón de varios tipos usando SQL.
Sintaxis:
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
Primer patrón:
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
Producción :
* * * * * * * * * * * * * * *
Segundo patrón:
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
Producción :
* * * * * * * * * * * * * * *
Tercer patrón:
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
Producción :
*
**
***
****
*****
Cuarto patrón:
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
Producción :
*****
****
***
**
*
Publicación traducida automáticamente
Artículo escrito por DevanshuAgarwal y traducido por Barcelona Geeks. The original can be accessed here. Licence: CCBY-SA