Advertisements
 
 Advertisements
sportsappsios musicappsios educationappsios

Database related

Executing Transact-SQL INSERT statement  Executing Transact-SQL INSERT statement

 In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database....

Connections, Commands and Procedures  Connections, Commands and Procedures

 Connections, Commands and Procedures is a sample chapter from Professional Active Server Pages which discuss in depth all the issues related with establishing connection to a database to the carrying out of commands and procedures....
Tags:

SQL Reserved Words  SQL Reserved Words

 Many times people will make the mistake of naming a database field with an SQL Reserved word. This is an easy mistake to make. It`s hard to remember every single one. Here`s a concise listing of SQL Reserved words to help you along....

Executing Transact-SQL DELETE statement  Executing Transact-SQL DELETE statement

 In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database....

Convert to Comma-Delimited File  Convert to Comma-Delimited File

 This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement using ASP....
Tags:

Uploading Images to Database Using Persist AspUpload  Uploading Images to Database Using Persist AspUpload

 You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server....

Fun With Stored Procedures...  Fun With Stored Procedures...

 This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others. A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures....

Making the Switch from ODBC to OLE DB  Making the Switch from ODBC to OLE DB

 ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. This tutorial will show you how to do it two ways: in the global.asa and in any ASP page....
Tags:

ASP Data Access for Beginners  ASP Data Access for Beginners

 The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft`s Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC)....

Counting Records In A Database Table  Counting Records In A Database Table

 We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset....

Using SUM Function in An SQL Statement  Using SUM Function in An SQL Statement

 Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles....

ASP and Databases  ASP and Databases

 The ASP data access component is one of the most powerful features of ASP. With this component you are able to interface your database(s) directly with your webserver. Database access in ASP is, or can be, very complex. This online tutorial focuses on just a few objects to help you get started with the basics and you can then move forward from there....

Using Disconnected Recordsets  Using Disconnected Recordsets

 This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use them, and what advantages they offer over connected Recordsets. Also examines how to create custom, disconnected Recordsets....

Named Recordsets  Named Recordsets

 This article by James Shaw demonstrates how to dynamically add properties to an object (expando properties) - by implementing a function to create named recordsets....

Search db by Field  Search db by Field

 Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations....

SQL In Simple English - Part II  SQL In Simple English - Part II

 This is the second article in this series. This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners....

Integrating User Search with ASP and SQL Server Full-Text Search  Integrating User Search with ASP and SQL Server Full-Text Search

 This article provides sample source code for a user query parser which allows users to submit full-text search queries from ASP to SQL Server 2000. Full source code available for download....

Fastest way of Database Access : Caching Records in Memory  Fastest way of Database Access : Caching Records in Memory

 A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo available....

Executing Transact-SQL UPDATE statement  Executing Transact-SQL UPDATE statement

 In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database...

Generating random records from the Database  Generating random records from the Database

 This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download....

 

 

Pages :  1 2 3 4 5 6 7 8