sql programming
No Need For a SQL Tutorial Or to Learn SQL
Many proprietary database systems come with a report writer but are too difficult to use. They need a knowledge of SQL or they need an expensive expert to prepare the report. Sometimes there is no report writer available at all. Here is a solution.
SQL Tutorial For Beginners
Learn the basics of SQL quickly and easily in this easy to follow SQL tutorial. Learn how to query, add, modify and delete records in your Oracle database tables using SQL with this short tutorial.
Scalar subqueries tips for Oracle 9i
Scalar subqueries are a powerful enhancement to Oracle9i SQL. They allow for quick formulation of extremely complex SQL statements. Oracle’s introduction of scalar subquery support is another example of the company’s commitment to keeping pace with the evolution of the SQL language.
SQL Server Triggers
Triggers are stored procedures which are fired when data is modified in an underlying table. They can evaluate data being added to a table for validation purposes, or can make changes in that or other fields depending on the value of that data. You can use them even to execute a separate stored procedure, or to roll back a data modification or an entire transaction.
MySQL and BLOBs
One of MySQL's strengths is its use of Binary Large Object (BLOB) columns. These columns store unprocessed binary data, typically files, that can be retrieved and manipulated like the other common datatypes. The difficulty comes in accessing the BLOB column in VB. Prior to ADO 2.5, the only way to move data in and out of a MySQL BLOB column using Visual Basic was to use the appendchunk and getchunk methods. With ADO 2.5, the stream object has been added, greatly simplifying the process of working with MySQL BLOBs. In this article, I will focus entirely on using the stream object.
| Related News: |
