Lets see how to print a Xmas or Christmas Tree in SQL Server.
The best way of implementing a Xmas tree pattern you can use a Recursive CTE, as shown in below T-SQL.
Note that: After writing a below T-SQL, execute your query with Results to text for better format.
WITH CTE AS ( SELECT CAST(REPLICATE(' ', 10) + '^' AS NVARCHAR(100)) AS Pattern, 0 AS n UNION ALL SELECT CAST(REPLICATE(' ', 9 - n) + 'O' + REPLICATE('V', 2 * n + 1) + 'O' AS NVARCHAR(100)), CTE.n + 1 FROM CTE WHERE n < 10 ) SELECT Pattern As 'Happy Merry Christmas !! ' FROM CTE UNION ALL SELECT CAST(REPLICATE(' ', 8) + '| |' AS NVARCHAR(100)) AS Pattern UNION ALL SELECT CAST(REPLICATE(' ', 5) + '~~~``~~~' AS NVARCHAR(100)) AS Pattern
Also Read..
Displaying Emoji in SQL Server
Create a custom shortcuts in SQL Server
Displaying line numbers in Query Editor Window
2,961 total views, 2 views today
Pingback: Drawing with DB2 for i SQL – Happy New Year 2022! – Built on Power