Articles related to "Sql Statements"



How to Use SQL Statements with VBScript
The contents of a database (such as Microsoft Access) can be examined and modified by using VBScript and the insert, update, delete and select statements.
microsoft access windows programming vbscript programming insert update delete select statements sql statements

How to Use a MySQL Database in a Perl Program
A MySQL database will always form a suitable backend for any application, and the Perl programmer will find that this can be achieved very easily.
perl tutorial perl examples perl application development perl mysql perl run database query

Generating Dynamic HTML using DBI and CGI Modules
This article discusses the basics on generating Dynamic web pages using the CGI and DBI modules
dbi cgi perl linux windows

How to Add Records to MySQL With C#
As well as viewing data in a MySQL database, a C# programmer can add information by using the SQL insert statement and the MySQL .NET connector
database programming c# application programming developing c# database application sql insert update mysql database

MYSQL Custom Field Sorting
In MYSQL the sorting of recordset data can be easily setup and maintained with a few custom tables and a little thought.
mysql custom sorting custom sorting mysql mysql sorting database creation

MYSQL Custom Field Sorting Revisited
At times in MYSQL an unnatural sort is required. This article presents an easy to maintain set of tables where sorting a table in any order can be easily defined.
mysql custom sorting custom sorting mysql sql mysql sorting

SQL Server Training First Steps
Key to providing web interactivity is understanding SQL server, and how to interface with SQL databases. This SQL tutorial provides enough training to get started.
sql tutorial sql server add function new sql sql database relational database

How to Run Multiple MySQL Queries with PHP
It is very easy to work with MySQL queries and PHP and it's nearly as easy to process more than one SQL statement at the same time. Just use the mysqli multi_query method
php application development php mysql php mysqli multi_query php sql statements running database queries php

How to Run MySQL Queries with PHP
SQL statements are used to obtain data from databases. A PHP programmer can use them with the mysqli object to build a very powerful application.
php programming php mysql mysqli php sql statements php select insert update delete sql structured query language

Install SQL Server 2005 Express
Ready to start programming SQL Server 2005? Here is a concise walk-through of the steps for obtaining and installing all the necessary software.
sql server 2005 express edition sql server management studio express sql server 2005 sql programming learning sql

Connecting to MySQL from PowerShell
PowerShell is Microsoft's .NET scripting language. If the programmer combines this with the MySQL .NET connector then they can build a very powerful database application
microsoft windows powershell mysql .net connector database access database .net application windows powershell tutorialexample

Decision Support Systems and Data Warehousing
Some insight into the different technologies available is useful in the analysis of data warehousing/data mart requirements leading to a CRM solution.
decision support systems (dss) virtual data warehouse multi-dimensional online data processing(olap) relational olap data mart

How to Create an Access Database with VBScript
There is no need for a database designer to manually create a Microsoft Access database - they can automate the process using VBScript.
microsoft access database automate table creation table insert sql vbscript vbs application vbscript computer programming

MySQL Stored Procedures and Triggers
MySQL stored procedures and triggers are a powerful tool in the hands of a database developer. This articles looks at how to use them to automate tasks on a database.
mysql stored procedures mysql triggers automating mysql databases database programming stored procedures and triggers

Using Microsoft Access and ODBC Data Sources
Use Perl in Windows to interact with Microsoft Access and other ODBC data sources in Windows.
microsoft access odbc perl activeperl windows

Working with Records and Fields in VBScript
VBScript (the scripting language for Visual Basic) can make the processing of records and fields in a recordset very easy for the database programmer.
visual basic scripting vbscript microsoft access database programming recordset record field running sql query

How to Use the PHP Text Database API
Not all web servers have a database (due to technological or financial constraints). However, the PHP programmer can still use SQL with the PHP Text Database API.
php text database api php database sql php text-db api running database queries php create database table


| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | 0-9 |