Home
Web
Client-Side Development
Server-Side Development
Computers & Networking
IT Tools
SQL
Introduction to SQL
What is ODBC?
Install SQL Server
SQL SELECT Statement
SQL INSERT INTO Statement
SQL DELETE Statement
SQL UPDATE Statement
SQL Order By Keyword
SQL TOP Clause
SQL Where Clause
SQL AND/OR Operators
SQL LIKE Operator and Wildcards
SQL IN Operator
SQL Between Operator
Assigning an Alias to Columns and Tables
Joining Tables and Views
SQL INNER Join
SQL LEFT Join
SQL RIGHT Join
SQL FULL Join
SQL UNION Operator
SQL SELECT INTO
SQL AVG Function
SQL COUNT Function
SQL MIN Function
SQL MAX Function
SQL SUM Function
SQL UPPER, UCASE Function
SQL LOWER, LCASE Function
SQL LEN Function
SQL ISNULL, NVL, and IFNULL Function
SQL ROUND Function
SQL Date Functions Overview
Date Formatting
SQL GETDATE Function
SQL DATEPART Function
SQL DATEADD Function
SQL DATEDIFF Function
MySQL NOW Function
MySQL CURDATE Function
MySQL CURTIME Function
MySQL DATE Function
MySQL EXTRACT Function
MySQL DATE_ADD Function
MySQL DATE_SUB Function
MySQL DATEDIFF Function
MySQL DATE_FORMAT Function
SQL DROP Statement
SQL TRUNCATE Table Statement
SQL CREATE DATABASE Statement
SQL CREATE TABLE Statement
SQL CREATE VIEW Statement
SQL ALTER Statement
Stored Procedures
Stored Procedure Parameters
SQL IF…ELSE Statement
SQL Cursors
Sending Email Using CDOSYS
Returning Data From a Stored Procedure
Querying Active Directory from SQL
Leveraging Temporary and Variable Tables in SQL
ASP
Introduction to Active Server Pages (ASP)
Server Side Scripting with ASP
Running ASP on a Web Server
Basic Syntax for ASP
Declaring Variables in ASP
Working with Operators in ASP
Adding Comments in ASP Code
ASP Special Characters
ASP Conditional Statements
ASP Functions and Subroutines
ASP Looping Statements
Using the #include Directive in ASP
ASP Session Object
ASP Application Object
ASP Global.asa
ASP Response Object
Redirect Methods Using ASP
Managing Caching Options with ASP
ASP Request Object
ASP QueryString Collection
ASP Form Collection
ASP ServerVariables Collection
ASP Cookies Collection
ASP Server Object
Using a DLL in your ASP Application
Formatting the Date in ASP
Sending Email Using CDOSYS in ASP
ASP FileSystem Object
ASP TextStream Object
ASP File Object
ASP Folder Object
ASP Drive Object
ASP Database Access Using ADO
ADO
Introduction to ADO
ADO Components
ADO Connection Object
ADO Recordset Object
ADO Command Object
What is ADOVBS.inc
ADO Querying a Database
ADO Displaying Data in a Table
ADO GetString Method
ADO Inserting Records in a Database
ADO Updating Records in a Database
ADO Deleting Records in a Database
ADO Capturing Errors
ASP.NET
Introduction to ASP.NET
Creating a Basic ASP.NET Page
ASP.NET HTML Server Controls
ASP.NET Web Server Controls
ASP.NET Web Forms
Using Server-side Comments in ASP.NET
Create an RSS Feed for your Website
Create a Sitemap XML File for your Website
Did you find the page informational and useful? Share it using one of your favorite social sites.