Tags → Query Sql Tutorial

Ad Hoc Queries in ASP.NET

Ad hoc SQL query is dynamically created when needed to return information like database search results, user profile info or more generally, any information that are related to user specific request. This tutorial explains how to build ad hoc queri...

• Categories
  • ASP.NET →
  • Tips and Tutorials
• Platforms
  • Windows
• Licenses
  • Freeware

SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution

A collection of 18 FAQs on connecting to MS SQL Server with PHP scripts. Clear explanations and tutorial exercises are provided on SQL Server connection; providing port number; selecting database; running SQL statements; checking execution errors; lo...

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux
• Licenses
  • Freeware

GalaXQL

GalaXQL is an interactive SQL tutorial. Follow the instructions by your virtual teacher. The teacher can understand several possible mistakes that you may make, and gives hints on what may have gone wrong. You can skip to any chapter in the tutorial ...

• Categories
  • Tools and Utilities →
  • Database Tools
• Platforms
  • Linux,
  • Windows,
  • Mac OSX
• Licenses
  • Freeware

Formatting Date/Time value in SQL query

Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux
• Licenses
  • Freeware

SQL Tutorial

SQL, Structured Query Language, is the most powerful tool to connect to a database regardless of the form of the database. However, building a perfect SQL statement can be very frustrating. Especially debugging -- the error message simply didn''...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

So you want to use a database in your site?

In this two-page online tutorial you will learn how to create a database-driven site that can display content on request. It covers topics on a simple SQL query interface and more complex example of parsing and querying.

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux
• Licenses
  • Freeware

MySQL Table Joins

One of the great characteristics of SQL (Structured Query Language) is the fact that one can develop access and modify data across various tables. There are several benefits to this, including greater ease of manipulation, increased speed of access, ...

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux
• Licenses
  • Freeware