QuakeFinger is a good example of using Active Server Pages (ASP) to create web sites that seamlessly integrate with SQL databases.
QuakeFinger is completely dynamically created, and draws 95% of the displayed information from a SQL database.