 
		
		  
		   | SQL, Structured Query  Article describes what is  This article shows how to  Many a time, you are  Language, is the most  SQL? what it is used for?  generate random records from  confronted with creating a  powerful tool to connect to  how to SELECT, INSERT,  the database. Also explains  system DSN for use with ASP.  a database regardless of the  UPDATE and DELETE records  how to generate random  If you have an ISP account,  form of the database.  from the database? and more.  numbers. Sample Database and  this might take time and  However, building a perfect  Code available for download.  more than sometimes - money.  SQL statement can be very  This article describes how  frustrating. Especially  to use File DSNs and save  debugging -- the error  time and money. Also, you  message simply didn't tell  can reuse these DSNs and  you where the error is. This  thus, with some  tutorial provides a nice  modifications, use the same  summary of SQL statements.  DSN for as many database  connections.  Date: Feb, 15 2000 Date: Mar, 13 2002 Date: Aug, 30 2000 Date: Jan, 25 2000 | 
| This article by James Shaw  Sometimes, we would have  Connections, Commands and  This article describes how to  demonstrates how to  chance to convert our  Procedures is a sample  use Microsoft SQL Server  dynamically add properties  existing database or create  chapter from Professional  triggers to automatically  to an object (expando  a new database. Some  Active Server Pages which  record all updates and  properties) - by  decisions IT professionals  discuss in depth all the  inserts for a particular  implementing a function to  need to make are scary, and  issues related with  database table in a  create named recordsets.  choosing database software  establishing connection to a  customized history table.  is one of them. This  database to the carrying out  overview aims to describe  of commands and procedures.  how to set database  connections with some common  database software (Oracle,  MySQL, MS Access,MS SQL  Server).  Date: Dec, 16 2000 Date: Sep, 01 2003 Date: Mar, 20 2000 Date: Sep, 20 2001 |