Data Transformation Services (DTS) is a group of utilities and objects used to automatically perform extract, transform and load operations to or from databases. DTS is widely used with Microsoft SQL Server databases. DTS was a feature of Microsoft SQL Server from version 7.0 through SQL Server 2000. It was replaced by SQL Server Integration...
A binary operator is an operator that operates on two operands and manipulates them to return a result. Operators are represented by special characters or by keywords and provide an easy way to compare numerical values or character strings.
Binary operators are presented in the form:
Operand1 Operator Operand2
Some common binary operators in computing include:
Equal (==) and not-equal (!=) are called equality operators. They produce a result of true (or 1) or false (or 0). This type of operator returns "true" if both operands have the same value, or "false" if they don’t have the same value.
For example, the following conditional operation will be performed if the operands are equal:
if(operand1 == operand2)
//do the operation
Greater than (>), less than (<), greater than or equal to (>=) and less than or equal to (<=) are relation operators, which compare two operands and produce a result of either true or false. When two operands are compared, the result depends on the relative location of the two operands.
Logical AND (&&) and logical OR (||) are called logical operators. They compare operands and return a result of either true (1) or false (0). In logical AND, if both operands are true then the result is true. If either one of the operands is false, the result will be false. In logical OR, if both operands are true or either one of the operands is true then the result is true. If both operands are false then the result will be false.
Read More »
Join 138,000+ IT pros on our weekly newsletter
Home | Advertising Info | Write for Us | About | Contact Us
2010 - 2015
Partner Sites :