Querying Active Directory from SQL

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 …

What is ODBC?

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

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

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

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

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

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

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

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

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

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

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 …

Scroll to Top