Articles related to "Sql"



SQL Server Transact-SQL Primer
SQL programming is at the heart of today's Web 2.0 applications. Learn the basic 4 commands SELECT, UPDATE, INSERT and DELETE.
transact-sql sql server 2005 database programming learn sql sql primer

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

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

Transact-SQL Primer: Inner Join
A basic SQL concept that should be mastered is that of "joins." Joins allow for the display of data from different tables to be combined with specific relationships.
sql inner join inner join sql joins sql data in different tables transact-sql

How to Create Database Tables Using BASE
This example shows how to create a simple address book. This database can be created in under ten minutes by a user with little to no experience using OpenOffice.org BASE
how to create a database table using base create a database table create a database table using openoffice.org base openoffice.org base openoffice.org

Using Batch Files to Create MySQL Databases
A batch file provides an historical record when creating MySQL databases and the objects in them (tables, views and stored procedures)
mysql stored procedures batch file run sql mysql database create database

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

New Microsoft Exams
New Microsoft Exams for June, 1999.
mcse microsoft certification windows nt

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 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

Programming Inner and Outer Joins in a Query
SQL queries can extract data from single or multiple tables. How that data is extracts greatly affects what the programmer can obtains - and it all comes down to the join
sql inner outer join sql outer left right join database application programming microsoft access database programming visual basic vbscript script programming

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 Access MySQL with C#
C# and MySQL make a very powerful combination, and it's all made possible by using the MySQL .NET connector
c# c sharp mysql c# database mysql .net connector c# sql queries

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 Use the MySQL Data Reader
One real advantange to using the Microsoft .NET framework is that the same objects (such as a data reader) can be used in multiple applications using different languages.
microsoft windows programming application development c# mysql powershell mysql mysql data reader

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

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

Connect MySQL and OpenOffice.org BASE
Article provides a quick tutorial on how to connect MySQL and BASE from OpenOffice.org on a MS Windows computer with the MySQL Connector/J for Java Database Connectivity.
connect mysql and base using jdbc on windows installing jdbc on windows mysql connector/j open source database

BlackBerry Enterprise Server (BES) Disaster!
BlackBerry Enterprise Server (BES) is a simple piece of software to install, but when it goes bad, it goes really bad. Learn how to avoid a BES installation disaster.
blackberry enterprise server (bes) bes blackberry enterprise server bes won't install bes installation help

Certification Getting Harder All the Time
mcse, mcsd, microsoft certifcation, microsoft training, windows nt
mcse mcsd microsoft certification microsoft training windows nt

Microsoft Certification Pays Big Dividends
certification
msce networking computer industry certified

Re-Discover: LeVert
Welcome to a new article segment. Re-Discover will appear periodically to offer reflections on artists or bands that haven't blessed us with new music lately...but should.
gerald levert shawn levert marc gordon o'jays eddie levert

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

Using Multi-Dimensional Arrays in Perl
This article shows you how multi-dimensional arrays are created in Perl
perl array linux multi-dimensional arrays windows

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

Applying Referential Integrity to a Database
When not properly linked, badly connected tables can cause inefficiency to data retrieval. Eventually the database needs to be fixed by hand, at cost.
referential integrity data integrity database integrity sql design integrity

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

How To Create an OpenOffice.org Database Log On
When looking an OpenOffice.org database there is no way of adding user accounts. Not directly, anyway. The secret is to use a little bit of SQL.
openoffice.org base database add user account username password hsqldb sql database admin admistrator account create user password

MySQL Stored Procedures and Functions
Oracle, unlike MySQL, has stored procedures and functions available for the database developer, giving Oracle a major advantage. That's all changed with MySQL 5.
oracle databases mysql databases stored procedure stored function subroutines and functions

IT In Business: Business IT Development - Data
Vast amounts of data and information are available to business managers, yet each generation continues to fall to the same pattern of mistakes.
controlling it controlling the it function it in business it help for managers it costs

Sting's Policing of Neil Finn
This article explores the interesting connections between Sting and Neil Finn, formerly of Crowded House.
sting the police crowded house neil finn tim finn

How to Get User Information with PHP
Many web pages require their users to input data. The questions can be asked and the answers processed by using some simple PHP code.
php application programming html form processing php php form $_request mysql create user php register user

Using a MySQL Database with C++
C++ and MySQL are both very powerful, but when combined they can make a killer application.
c++ programming mysql database stored procedures stored functions c++ code

mod_perl Handlers: Defining Handlers
This article gives a brief introduction on how to define handlers in mod_perl.
mod perl modperl apache handler filter

Re-Discover: Guy
Welcome to a new article segment. Re-Discover will appear periodically to offer reflections on artists or bands that haven't blessed us with new music lately...but should.
guy blackstreet teddy riley aaron hall damian hall

The Wisconsin Blues
Learn how "the Blues" and "Jazz" came to Wisconsin in the 1920s and 30s. Discover how Paramount Records, based in Port Washington and Grafton, Wisconsin, became one of the first recording companies to introduce "race records".
wisconsin port washington grafton paramount records blues

How to Create a Database using BASE
This article is a short tutorial on How to Create a Database using OpenOffice.org BASE. In this tutorial the user can create a database shell in OpenOffice.org BASE.
what are databases types of databases why use openoffice.org base how to create a database using base create database

Review of Paul Kelly's "Words and Music"
Paul Kelly has the reputation of being one of Australia's best singer- songwriters.
paul kelly singers songwriters rock music australian

Waiting for Windows 2000
Waiting for the release of Windows 2000
mcse windows nt windows 2000 mcsd microsoft

Indexing Service
A description of the Indexing Service
indexing service processes windows services windows xp windows 2000

More Certification Stuff
A few changes to certification, Windows NT name change and release date.
microsoft certification mcse windows nt

Offline Web Applications
Offline Web Applications that provide the possibility to use all web applications without relying on Internet connection will be viewed as a veritable boon by one and all
offline web applications common web applications http cache mechanism data and server specification for network connecti application cache mechanism in web applications

MICROSOFT CERTIFICATION UPDATE
microsoft certification, microsoft training, mcse, mcsd, windows nt
microsoft certification microsoft training mcse mcsd windows nt

SAVING TIPS
microsoft training, microsoft certification, mcse, mcsd
microsoft training microsoft certification mcse mcsd

Bean Salads
Some bean cooking tips and lots of recipes for delicious bean salads.
vegetarian vegan beans bean salad picnic

Jimmy C. Newman, Legendary Cajun Singer
World-famous Cajun musician Jimmy C. Newman was recently honored as a Living Legend by the Acadian Museum of Erath in south Louisiana.
cajun music jimmy c. newman louisiana grand ole opry

Re-Discover: Switch
That's right - these groups were hot when you had stacks of wax and tons of tapes!
debarge switch

Amy Grant Revisits Lead Me On
Considered one of the greatest Christian albums ever, "Lead Me On" from Amy Grant is celebrated with a new double disc 20th Anniversary Edition CD and a tour this fall.
amy grant lead me on amy grant lead me on 20th anniversary edition cd amy grant lead me on 20th anniversary celebration lead me on amy grant lead me on 20th anniversary edition cd

Employment Opportunities in Computer Science
When people visualize a librarian's job, most visualize a boring existence; actually, jobs in library science are being shaped by exciting new technology.
jobs in computer science system librarian jobs and careers technology jobs paying $40 000 or more top jobs with employment growth


| 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 |