|
|
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.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
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 DELETE statement creates a query that removes records from one or more tables
|
|
|
|
|
|
|
The DROP statement can be used to delete an existing index from a table...
|
|
|
|
|
|
|
The FIRST function is used to return the value of the first record in the designated field Therefore, this function returns a single value.
|
|
|
|
|
|
|
The optional GROUP BY clause combines into a single record all records that have identical values in a particular field or combination of fields.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
Votes:139
Hits:1986
