Subscribe
Tutorial search

ASP Tables Tutorials


Sort by:
SQLServerTools Object
SQLServerTools Object
This example shows how to get a list of all current tables in the database, get a list of dependent stored procedures for each table and do it all in a stored procedure.
Difficulty:
Two Table Join
Two Table Join
Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.
Difficulty:
MS Access: Tables, Views and Procedures
MS Access: Tables, Views and Procedures
Ever wondered how to create a table, view or procedure with MS Access? This article shows us how to create all three and work with them from an ASP script.
Difficulty:
Search Term(s) (1): tables