How to print diamon in sql

Question

enter image description here

I wanted to draw a dimaond like this in Sql. Can you help me please

Answer 1

I have find this code in queryexamples.com there are to many examples like this

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