ASP.NET Server-Side Data Acces
Introduction to Server-Side Data
Connections, Commands, and DataSets
Accessing SQL-based Data
Binding SQL Data to a DataGrid
Performing a Parameterized Select
Inserting Data in a SQL Database
Updating Data in a SQL Database
Deleting Data in a SQL Database
Sorting Data from a SQL Database
Working with Master-Detail Relationships
Writing and Using Stored Procedures
Accessing XML-based Data
Section Summary
Read more
VBScript Database Tutorial Part 1 to 4
Probably the most popular use for ASP scripting is connections to databases. It’s incredibly useful and surprisingly easy to do. The first thing you need is the database, of course. A variety of programs can be used to create it, but probably the most popular is Microsoft Access. You can also use FoxPro or create it directly in an SQL Server using whichever utilities are supplied with the server (Enterprise Manager in the case of Microsoft SQL Server), or native SQL commands.
Read more
SQL Subqueries Counterparts in Tutorial D
SQL uses the term subquery to refer to a table expression (commonly known as a query) that is contained within another table expression. Until 1992, as far as the international standard for SQL is concerned, subqueries were permitted only inside conditional expressions (i.e., truth-valued expressions), and conditional expressions were permitted only inside the WHERE clause, and the HAVING clause. Nowadays subqueries are permitted in the FROM and SELECT clauses too (and truth-valued expressions can appear in the SELECT clause, but we don’t need to look at examples of those here).
Read more
Informix Guide to SQL Tutorial
The Informix Guide to SQL: Tutorial includes instructions for using basic and advanced Structured Query Language (SQL) as well as for designing and managing your database. This manual is part of a series of manuals that discusses the Informix implementation of SQL. Once you finish reading this manual, you can use the Informix Guide to SQL: Reference and the Informix Guide to SQL: Syntax as references to help you with daily SQL issues.
Read more
Introduction to Structured Query Language
This page is a introductory tutorial of the Structured Query Language (also known as SQL) and is a pioneering effort on the World Wide Web, as this is the first comprehensive SQL tutorial available on the Internet. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows users to define the data in a database, and manipulate that data. This page will describe how to use SQL, and give examples. The SQL used in this document is “ANSI”, or standard SQL, and no SQL features of specific database management systems will be discussed until the “Nonstandard SQL” section. It is recommended that you print this page, so that you can easily refer back to previous examples.
Read more