Concatenate Columns - Revision history

Marek at 13:01, 12 July 2012

2012-07-12T13:01:24Z

2012-07-12T12:55:51Z

2012-07-12T12:55:36Z

2012-07-11T13:48:42Z

2012-07-11T13:46:22Z

2012-07-11T13:44:24Z

2012-07-11T13:41:51Z

2012-07-11T11:17:04Z

2012-07-11T08:25:39Z

2012-07-10T15:36:26Z

@@ Line 1: / Line 1: @@
 You can put two or more strings together using the concatenate operator.
 <div class='ht'>
-<div class=params>schema:scott</div>
+<div class=params>schema:gisq</div>
 <div>
 You can put two or more strings together using the concatenate operator.
@@ Line 7: / Line 7: @@
 between the main vendors.
 </div>
-<source lang=sql class='tidy'>DROP TABLE bbc;
+<source lang=sql class='tidy'></source>
-</source>
+<source lang=sql class='setup'></source>
-<source lang=sql class='setup'>CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
-INSERT INTO bbc VALUES ('Poland', 'Europe');
-INSERT INTO bbc VALUES ('Japan', 'Asia');
 </source>
 <source lang='sql' class='def e-access'>SELECT region & name
    FROM bbc</source>

@@ Line 1: / Line 1: @@
 You can put two or more strings together using the concatenate operator.
 <div class='ht'>
+<div class=params>schema:scott</div>
 <div>
 You can put two or more strings together using the concatenate operator.

@@ Line 1: / Line 1: @@
 You can put two or more strings together using the concatenate operator.
 <div class='ht'>
-<div class=params>schema:scott</div>
 <div>
 You can put two or more strings together using the concatenate operator.

@@ Line 7: / Line 7: @@
 between the main vendors.
 </div>
-<source lang=sql class='tidy'>CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
+<source lang=sql class='tidy'>DROP TABLE bbc;
 INSERT INTO bbc VALUES ('Poland', 'Europe');
 INSERT INTO bbc VALUES ('Japan', 'Asia');

@@ Line 1: / Line 1: @@
 You can put two or more strings together using the concatenate operator.
 <div class='ht'>
-<div class=params>database:scott</div>
+<div class=params>schema:scott</div>
 <div>
 You can put two or more strings together using the concatenate operator.

← Older revision		Revision as of 11:17, 11 July 2012
Line 23:		Line 23:
	<div class="ecomm e-mysql" style="display: none">Use CONCAT</div>		<div class="ecomm e-mysql" style="display: none">Use CONCAT</div>
	</div>		</div>
		+	{{SELECT Ref}}

@@ Line 2: / Line 2: @@
 <div class='ht'>
 <div>
-You can put two or more strings together using the concatentate operator.
+You can put two or more strings together using the concatenate operator.
 The SQL standard says you should use || but there are many differences
 between the main vendors.
@@ Line 22: / Line 22: @@
 <div class="ecomm e-sqlserver" style="display: none">Use +</div>
 <div class="ecomm e-mysql" style="display: none">Use CONCAT</div>
 </div>

@@ Line 20: / Line 20: @@
 </source>
 <div class="ecomm e-access" style="display: none">Use ampersand: &</div>
-<div class="ecomm e-sqlserver"style="display: none">Use +</div>
+<div class="ecomm e-sqlserver" style="display: none">Use +</div>
-<div class="ecomm e-mysql"style="display: none">Use CONCAT</div>
+<div class="ecomm e-mysql" style="display: none">Use CONCAT</div>
 </div>