Print Pattern Examples Using Sql

There are 11 star pattern examples in this tutorial. I will add more example…

In Sql we use replicate function to print pattern easily.

How Replicate Function Works In Sql

The Replicate function get to parameters. The first parameter is the character we want to print and the second parameter is, how many times we want to print the character. Example Select replicate(‘*’,5); The Code prints star character 5 times side by side. Now we can print patterns ;

1. Pattern: Print Left Triangle Example

Declare @i int
Set @i = 1
while @i<10
Begin 
	Print replicate('*',@i)
	Set @i = @i + 1
End

Declare @i int

Set @i = 1

while @i<10

Begin

Print replicate('*',@i)

Set @i = @i + 1

End

2. Pattern: Print Right Triangle Example

Declare @i int=1
Declare @max int = 10
While @i<@max
Begin
	Print space(@max-@i)+replicate('*',@i)
	set @i = @i + 1
end

Declare @i int=1

Declare @max int = 10

While @i<@max

Begin

Print space(@max-@i)+replicate('*',@i)

set @i = @i + 1

end

3. Pattern: Print Reverse Left Triangle Example

DECLARE @i int = 5              
WHILE @i > 0                 
BEGIN                          
PRINT replicate('* ', @i)    
SET @i = @i - 1            
END

DECLARE @i int = 5

WHILE @i > 0

BEGIN

PRINT replicate('* ', @i)

SET @i = @i - 1

END

4. Pattern: Print Reverse Right Triangle Example

Declare @max int = 7
Declare @i int = @max
While (@i>0)
Begin
Print space(@max-@i)+replicate('*',@i)
Set @i=@i-1
End

Declare @max int = 7

Declare @i int = @max

While (@i>0)

Begin

Print space(@max-@i)+replicate('*',@i)

Set @i=@i-1

End

5. Pattern: Print Pyramid Example

Declare @i int,@max int
Set @i =1
Set @max = 11
While(@i<=@max)
Begin
	Print Space((@max-@i)/2) + replicate('*',@i)
	Set @i = @i + 2	
End

Declare @i int,@max int

Set @i =1

Set @max = 11

While(@i<=@max)

Begin

Print Space((@max-@i)/2) + replicate('*',@i)

Set @i = @i + 2

End

6. Pattern: Print Diamon Example

Declare @i int = 0,@max int = 11,@c int = 1
While (@i<@max)
Begin
	Print space(abs((@max-@c)/2))+ Replicate('X',@c)	
	Set @i = @i + 1
	if(@i>(@max/2))
		Set @c -= 2
	else
		Set @c += 2
End

Declare @i int = 0,@max int = 11,@c int = 1

While (@i<@max)

Begin

Print space(abs((@max-@c)/2))+ Replicate('X',@c)

Set @i = @i + 1

if(@i>(@max/2))

Set @c -= 2

else

Set @c += 2

End

7. Pattern: Print Twisted Sentence Example

Declare @i int,@j int,@a int ,@sentence varchar(40)
Set @sentence = 'queryexamples.com'
Set @i = 1
SEt @j = 3
Set @a = 3
while(@i<=len(@sentence))
Begin
	Print Space(@a-abs(@j))+Substring(@sentence,@i,1)
	Set @j = @j -1
	if (abs(@j)>@a)
		Set @j = @a-1
	Set @i = @i + 1
End

Declare @i int,@j int,@a int ,@sentence varchar(40)

Set @sentence = 'queryexamples.com'

Set @i = 1

SEt @j = 3

Set @a = 3

while(@i<=len(@sentence))

Begin

Print Space(@a-abs(@j))+Substring(@sentence,@i,1)

Set @j = @j -1

if (abs(@j)>@a)

Set @j = @a-1

Set @i = @i + 1

End

Result Of Code

8. Pattern: Print Pyramid Example

Declare @i int 
Declare @j int
Declare @a int
Declare @sentence varchar(15)
Set @sentence = 'QUERYEXAMPLES'
Set @i = 1
SEt @j = floor(len(@sentence))-2
Set @a = len(@sentence)%2
While(@i<=len(@sentence))
Begin
	if(@i<=floor(len(@sentence)/2))
		Print space(@i-1)+Substring(@sentence,@i,1)+Space(@j)+Substring(@sentence,@i,1)
	else if(@i>floor(len(@sentence)/2)+@a)
		Print space(len(@sentence)-@i)+Substring(@sentence,@i,1)+space(abs(@j))+Substring(@sentence,@i,1)
	else
		Print space(@i-1)+Substring(@sentence,@i,1)
	Set @i = @i + 1
	if (@i<>len(@sentence)/2 + 1)
		SET @j = @j - 2
End

Declare @i int

Declare @j int

Declare @a int

Declare @sentence varchar(15)

Set @sentence = 'QUERYEXAMPLES'

Set @i = 1

SEt @j = floor(len(@sentence))-2

Set @a = len(@sentence)%2

While(@i<=len(@sentence))

Begin

if(@i<=floor(len(@sentence)/2))

Print space(@i-1)+Substring(@sentence,@i,1)+Space(@j)+Substring(@sentence,@i,1)

else if(@i>floor(len(@sentence)/2)+@a)

Print space(len(@sentence)-@i)+Substring(@sentence,@i,1)+space(abs(@j))+Substring(@sentence,@i,1)

else

Print space(@i-1)+Substring(@sentence,@i,1)

Set @i = @i + 1

if (@i<>len(@sentence)/2 + 1)

SET @j = @j - 2

End

Result of Code

9. Pattern: Print Hollow Diamond Example

You can change max value to see different view. But the value must be odd number.

Declare @i int = 0,@max int = 7,@c int = 1
Print space(@max/2+1)+'X'
While (@i<@max)
Begin
	Print space(abs((@max-@c)/2))+ 'X'+space(abs(@c-1)+1) + 'X'	
	Set @i = @i + 1
	if(@i>(@max/2))
		Set @c -= 2
	else
		Set @c += 2
End
Print space(@max/2+1)+'X'

Declare @i int = 0,@max int = 7,@c int = 1

Print space(@max/2+1)+'X'

While (@i<@max)

Begin

Print space(abs((@max-@c)/2))+ 'X'+space(abs(@c-1)+1) + 'X'

Set @i = @i + 1

if(@i>(@max/2))

Set @c -= 2

else

Set @c += 2

End

Print space(@max/2+1)+'X'

Result of Code

10. Pattern: Print Right Arrow Example

Declare @i int,@a int
Set @a = 7
Set @i = -@a;
While (@i<@a)
Begin
	Set @i = @i + 1
	Print replicate('* ',@a - abs(@i))
End

Declare @i int,@a int

Set @a = 7

Set @i = -@a;

While (@i<@a)

Begin

Set @i = @i + 1

Print replicate('* ',@a - abs(@i))

End

Result of Code

11. Pattern: Print A Word Triangle Example

Declare @i int,@word varchar(20)
Set @i = 0
Set @word= 'QUERYEXAMPLES'
While (@i<LEN(@word))
Begin
	Set @i = @i + 1
	Print Substring(@word,1,@i)
End

Declare @i int,@word varchar(20)

Set @i = 0

Set @word= 'QUERYEXAMPLES'

While (@i<LEN(@word))

Begin

Set @i = @i + 1

Print Substring(@word,1,@i)

End

Result of Code

12. Pattern: Print Right Arrow – 2

Declare @i int,@a int
Set @a = 4
Set @i = -@a;
While (@i&lt;=@a)
Begin
	Set @i = @i + 1
	if(@i&lt;0)
		Print replicate('1 ',@a - abs(@i))
	else if(@i=0)
	Begin
		Print replicate('1 ',@a - abs(@i))
		Print replicate('2 ',@a - abs(@i))
	End
	else
		Print replicate('2 ',@a - abs(@i))
	
End

Declare @i int,@a int

Set @a = 4

Set @i = -@a;

While (@i<=@a)

Begin

Set @i = @i + 1

if(@i<0)

Print replicate('1 ',@a - abs(@i))

else if(@i=0)

Begin

Print replicate('1 ',@a - abs(@i))

Print replicate('2 ',@a - abs(@i))

End

else

Print replicate('2 ',@a - abs(@i))

End

That’s all for now. I will write new ones soon as possible. I hope you like it.

YOU MAY WANT TO SEE OUR ALL EXAMPLES PAGE, THEN CLICK HERE

2 Comments

Print Diamond Pattern Using Sql Example – Query Examples says:

October 3, 2018 at 9:12 am

[…] IF YOU WANT TO SEE MORE THAN CLICK […]

Print Right Triangle Using Sql Example – Query Examples says:

October 3, 2018 at 9:17 am

[…] IF YOU WANT TO SEE MORE PATTERN EXAMPLES THAN CLICK […]

Print Left Triangle Using Sql Example – Query Examples says:

October 3, 2018 at 9:18 am

[…] IF YOU WANT TO SEE MORE PATTERN EXAMPLES THAN CLICK […]

Print Pyramid Using Sql Example – Query Examples says:

December 16, 2018 at 12:30 am

[…] IF YOU WANT TO SEE MORE PATTERN EXAMPLES THAN CLICK […]

VARAHA RAI says:

September 3, 2021 at 1:38 pm

HEY I WANT A SQL QUERY FOR THISPATTERN
1
11
111
1111
11111
22222
2222
222
22
2

- admin says:
  
  November 12, 2021 at 10:31 pm
  
  Answer…
  Declare @i int,@a int
  Set @a = 4
  Set @i = -@a;
  While (@i<=@a) Begin Set @i = @i + 1 if(@i<0) Print replicate('1 ',@a - abs(@i)) else if(@i=0) Begin Print replicate('1 ',@a - abs(@i)) Print replicate('2 ',@a - abs(@i)) End else Print replicate('2 ',@a - abs(@i)) End

Print Pattern Examples Using Sql

Like this:

Related

2 Comments

Leave a Reply to VARAHA RAI X

Share this:

Like this:

Related

You may also like

2 Comments

Leave a Reply to VARAHA RAI X