Produce HTML code from SQL query


Is it possible to generate HTML code from SQL query? Answer is yes.

A SELECT query returns results as a rowset. You can optionally retrieve formal results of a SQL query as XML by specifying the FOR XML clause in the query.

By using FOR XML clause we can also return results in HTML format, but need to tweak a query a bit.
We can use this trick to generate some static HTML pages.
Continue reading “Produce HTML code from SQL query”

Python used for?

Python’s ease of use and compatibility across a variety of operating systems makes it an ideal language for a number of uses. Many complex websites either currently or historically have used Python to power their back ends, from YouTube to Instagram to Reddit, and thousands of other well-known examples. But Python isn’t only a web language.


What is Python programming ?

Python is a general-purpose programming language which can be used for a wide variety of applications. A great language for beginners because of its readability and other structural elements designed to make it easy to understand, Python is not limited to basic usage. In fact, it powers some of the world’s most complex applications and website.

Continue reading “What is Python programming ?”