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