SQL injection is a serious concern for webmasters, as an experienced attacker can use this hacking technique to gain access to sensitive data and/or potentially cripple your ...

I remember those old days when I had to write everything by myself. I wrote huge libraries to work with MySQL. Th...

Microsoft Great Plains version 10.0, 9.0, 8.0 is only supported on Microsoft SQL Server DB platform, which opens the whole world of SQL scripting for SQL programmer, ho...

IntroductionJoins, in SQL, are a way of linking Recordsets together.Usually, they involve restricting which data is returned in the output Recordset, although this is...

This tutorial is to guide you in the creation of Cascading combo/list boxes. That is when you have multiple combo/list boxes where the selection of an option in one determines the available optio...

BackgroundWhenever code is used there must be a way to differentiate the actual code (which should be interpreted directly) with literal strings which ...

To use a subquery (SQ) in SQL there are two ways :Treating the SQ as a record source (like a table). Treating the SQ as a single value....

Views are like snapshots of queries. You can save any query as a view, even complex queries with joins and subqueries, and MySQL will save the results of that query in a format that can be search...

Stored procedures are intensively used in SQL Server-based development today. The Perl language is the most useful administration language on the Unix/Linux environment. Since Web techn...

MySQL has become one of the most popular databases for Web applications. The database is well suited for common Web-related tasks like content management, and for implementing Web features like dis...