26 May 2009

🛢DBMS: Concatenation (Definitions)

"Combine expressions to form longer expressions. The expressions can include any combination of binary or character strings, or column names." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)

"Combining two or more character strings or expressions into a single character string or expression, or combining two or more binary strings or expressions into a single binary string or expression." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"A string operation consisting of assembling a string from two shorter strings." (Bill Pribyl & Steven Feuerstein, "Learning Oracle PL/SQL", 2001)

"The process of combining two or more character strings or expressions into a single character string or expression. Concatenation also refers to combining two or more binary strings or expressions into a single binary string or expression." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)

"The process of combining two or more data elements into a single element. In Oracle SQL, concatenation can be accomplished by using the concatenation operator (a pair of vertical bars, ||) or the CONCAT function." (Bob Bryla, "Oracle Database Foundations", 2004)

"Combining two strings by placing one at the end of the other." (Jan L Harrington, "SQL Clearly Explained 3rd Ed. ", 2010)

"The process of combining two or more character strings or expressions into a single character string or expression, or combining two or more binary strings or expressions into a single binary string or expression." (Microsoft, "SQL Server 2012 Glossary", 2012)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.