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?
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 …