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 …
SQL ISNULL, NVL, and IFNULL Functions
The SQL ISNULL function can be used to replace null values in the results of a query with alternate data. The ISNULL function is used by Microsoft SQL. Other SQL …
SQL IF…ELSE Statement
The SQL IF…ELSE Statement imposes conditions (boolean expression) on the execution of a Transact-SQL statement. The SQL statement(s) that follows an IF keyword is executed if the condition is satisfied …
Introduction to ASP.NET
Next version of ASP? Many people new to ASP.NET believe that ASP.NET is simply the next version of Active Server Pages (ASP). ASP.NET is actually more than the next version, …