ASP Folder Object
The ASP Folder object is used to access a specified file folder on the web server. As with other objects, the Folder object has properties and methods to help you …
Querying Active Directory from SQL
Microsoft’s object linking and embedding for database (OLE DB) providers can create connections to non-SQL Server data sources. Unlike the older ODBC standard, OLE DB can also connect to some …
Server Side Scripting with ASP
If you have already learned JavaScript, then you have an understanding of the concept of client-side scripting. Server-side scripting is similar, but with one major difference. The processing of the …
What is ODBC?
ODBC is a library designed to provide a common application programming interface or API. ODBC allows communication to the back-end database through a driver. The advantage to using ODBC is …
SQL INSERT INTO Statement
The INSERT INTO statement is used to insert a new row in a table. The INSERT INTO statement can be written in many forms to insert data into a table. If …
SQL UPPER, UCASE Functions
The UPPER function converts the value of a field to uppercase. The UPPER function is used for SQL Server. Other SQL platforms may use the UCASE function. Employees Table employeeID …
SQL DATEADD Function
The DATEADD function is used in Microsoft SQL Server to add or subtract a specified time interval from a date. Employees Table employeeID employeeName hireDate 1000 John Smith 1995-12-03 1001 …
MySQL DATE_ADD Function
The MySQL DATE_ADD function adds a custom time interval to a date. Employees Table employeeID employeeName hireDate 1000 John Smith 1995-12-03 13:23:30.657 1001 Fred White 2001-10-12 09:41:44.125 1002 Jane Scott …
MySQL DATE_SUB Function
The MySQL DATE_SUB function subtracts a custom time interval from a date. Employees Table employeeID employeeName retirementDate 1000 John Smith 2025-12-03 1001 Fred White 2031-10-12 1002 Jane Scott 2028-05-01 1003 …
SQL LOWER, LCASE Functions
The LOWER function converts the value of a field to lowercase. The LOWER function is used for SQL Server. Other SQL platforms may use the LCASE function. Employees Table employeeID …
SQL DATEPART Function
The DATEPART function is used in Microsoft SQL Server to return a single part of a date/time, such as year, month, day, etc. Employees Table employeeID employeeName hireDate 1000 John …
MySQL DATE Function
The MySQL DATE function extracts the date part of a date or date/time expression. The equivalent function in Microsoft SQL Server is somewhat DATEPART, but the CONVERT function may provide …