|
|
1-20 of 48 ASP Databases > SQL sites are shown.
|
|
This article describes how to establish connections to SQL Server within an ASP script using ActiveX Data Objects (ADO), while taking advantage of the connection pooling feature of ODBC 3.0.
|
|
|
|
|
|
|
Make a simple interface to generate SQL Statements which can be copied and pasted into your ASP code. This is not ment to support crazy queries, or advanced SQL, but more to serve as a way to speed up mundane coding.
|
|
|
|
|
|
|
You might think looping through a table with Stored Procedures is a simple task. Its probably more involved than you imagined. In order to loop through a table with a stored procedure you have to create a temporary table, add 1 record to it at a time for processing, and then delete the record.
|
|
|
|
|
|
|
This demo It's called ReturnValue.asp and shows you how to execute a stored procedure that has input params, output params, a returned recordset and a return value.
|
|
|
|
|
|
|
This demo shows how to do three things. First thing, “Format an EXEC statement string on an ASP Page with multiple parameters. Secondly, “Pass the string to a Store Procedure through ADO w/o using the Command object”. Third, “Returns the record set and writes the results to an ASP page”. We found using the Command object to be confusing. This demo shows how to do it without all of the code.
|
|
|
|
|
|
|
This article is designed to tell you how to begin writing stored procedures. I am using Microsoft SQL Server 7.0, but these examples should work in any SQL version.
|
|
|
|
|
|
|
This is the format for a stored proc where you want to pass parameters. This is a basic reference article the different ways you can create a stored Procedure, then pass it parameters to it.
|
|
|
|
|
|
|
SQL has a problem when dealing with ASP. If you try in an SQL statment to pass it a variable that contains an apostrophe you will get an error, normally a syntax error. Here is how you can fix this.
|
|
|
|
|
|
|
this article you will learn how to use the SELECT statement to produce more complex queries that involve multiple tables. We will use both the JOIN command and restrictions in the WHERE Clause to produce the desired output
|
|
|
|
|
|
|
This article explains an alternative to the boring string parse/loop method of building a search query for your website.
|
|
|
|
|
|
|
This article is a continuation of my previous article, Writing a Stored Procedure. Topics include how to execute non-SELECT SQL statements, and how to use the ADO Command Object to execute stored procedures from ASP
|
|
|
|
|
|
|
The COUNT function is one of the aggregate functions that are used to calculate statistical information for a specified numeric field in a query.
|
|
|
|
|
|
|
The CREATE INDEX statement is used to index one or more fields in an existing table
|
|
|
|
|
|
|
The LIKE operator allows you to compare values in a field to a string (or pattern) and see if there is a match.
|
|
|
|
|
|
|
The HAVING clause is optional and qualifies a GROUP BY clause. It is similar to the WHERE clause, but HAVING establishes restrictions that determine which records are displayed after they have been grouped.
|
|
|
|
|
|
|
The LIKE operator allows you to compare values in a field to a string (or pattern) and see if there is a match.
|
|
|
|
|
|
|
The LEFT JOIN and the similar RIGHT JOIN operations can be used in any FROM clause to combine records from two tables.
|
|
|
|
|
|
|
The INNER JOIN operation can be used in any FROM clause to combine records from two tables. It is, in fact, the most common type of join.
|
|
|
|
|
|
|
To add a specific record to a table, the INSERT INTO statement is followed by the name of the table and the names of the various fields.
|
|
|
|
|
|
|
The LAST function is used to return the value of the last record in the designated field Therefore, this function returns a single value.
|
|
|
|
|
|
Votes:154
Hits:2548
