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