2550SQL In Simple English - Part IIhttp://stardeveloper.com/go/006DBut why? I read Part I and I was able to implement a simple database program very easily. Why would I need to learn anything more?
You might have implemented some database program.. but I am sure it would be a very simple one. You may even be able to implement a good database program without Joins. But you wouldn't be using the features of SQL that let you do the same work much easily. Without Joins, you may manage SQL.. but with Joins you could do things very easilyASP > Tips and Tutorials > Database-relatedOct 10, 2006
This is a topic I've seen covered by others in the past but never in enough detail to satisfy me. This technique is extremely powerful and can yield huge performance gains over non-cached queries and therefore deserves more attention.
This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records were returned from a query, and how to detect null and blank values in the data.
code required for this page is very simple. A database connection is established and the database is queried for the record with the passed in ID. Then, the document's content-type is set to "image/gif" to let the browser know to interpret the coming data as an image. Finally, the Response.Binarywrite method is used to output the binary data from the database. Note how this is actually used in an IMG tag of an HTML page
The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC).
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.