Connection Type

Microsoft Excel is a component of MS Office application, which is useful to create spreadsheet. This Office utility is fruitful to create and maintain huge lists easily and effortlessly. It is used for storing contacts, doing statistical analysis, performing...

READ MORE - Connection Type

SQL ODBC connection

SQL ODBC connection stringsStandard Security:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;" Trusted connection:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;"...

READ MORE - SQL ODBC connection

SQL Functions

SQL Functions Keyword DescriptionCreate Function Ext_Orders(parmWhere CHAR(5)) CREATE FUNCTION names the UDTF and registers it with SQL. This function is called Ext_Orders (external orders). This name will be referenced by SQL statements using the function. You...

READ MORE - SQL Functions

C, C++ and Java Assignment Operators

C, C++ and Java Assignment Operators = -- simple assignment += -- add rhs, then assign to lhs -= -- subtract rhs, then assign to lhs *= -- multiply by rhs, then assign to lhs /= -- divide lhs by rhs, then assign to lhs &= -- bitwise and, then...

READ MORE - C, C++ and Java Assignment Operators

import java.sql

import java.sql.*; public class DataTransfer { private static String[] tableNames = new String[]{"SOME_TABLE_NAME"}; private static final int FETCH_SIZE = 100; public static void main(String[] args) throws ClassNotFoundException, SQLException { Connection...

READ MORE - import java.sql

Simple Database

A Simple Database Backup: You can use mysqldump to create a simple backup of your database using the following syntax. mysqldump -u [username] -p [password] [databasename] > [backupfile.sql] [username] - this is your database username [password]...

READ MORE - Simple Database

Central Management Service

The CMS store is used by the Central Management Service to maintain a current Lync Server 2010 Topology for the entire Lync deployment (Topology, Policies, Voice Routes, etc…). Here is what you need to know about the CMS: The database used for this purpose...

READ MORE - Central Management Service

Visual Basic

Visual Basic is an event-driven language. So, when you talk about events, we're talking about things that happen in the program which cause little events to occur (similar idea to IRQ stuff you learned hopefully in 455). An example of this could be clicking...

READ MORE - Visual Basic

SQL (Structured Query Language)

SQL (Structured Query Language) is a computer language aimed to store, manipulate, and query data stored in relational databases. The first incarnation of SQL appeared in 1974, when a group in IBM developed the first prototype of a relational database....

READ MORE - SQL (Structured Query Language)