Talk:String concatenation: Difference between revisions
Content added Content deleted
(→REXX ||: changed REXX language name to all uppercase.) |
m (added a talk section header for the first section, corrected a mispelling.) |
||
Line 1: | Line 1: | ||
== SQL string concatenation == |
|||
⚫ | |||
⚫ | |||
<lang sql>create table foo ( a varchar(10),b varchar(10)); |
<lang sql>create table foo ( a varchar(10),b varchar(10)); |
||
Line 7: | Line 9: | ||
::<code>select into</code> seems to be a non-standard extension to sql which is mostly used for creating backups of data in existing tables. Here, though, we have three lines -- the first two lines are analogous to variable declaration and variable assignment, and the last line illustrates the task requirement. That said, note that this || mechanism is the ansi standard way to concatenate string (introduced in sql-92) and some implementations of sql (such as mysql) [http://troels.arvin.dk/db/rdbms/#functions-concat do not support this syntax]. --[[User:Rdm|Rdm]] 19:28, 16 November 2010 (UTC) |
::<code>select into</code> seems to be a non-standard extension to sql which is mostly used for creating backups of data in existing tables. Here, though, we have three lines -- the first two lines are analogous to variable declaration and variable assignment, and the last line illustrates the task requirement. That said, note that this || mechanism is the ansi standard way to concatenate string (introduced in sql-92) and some implementations of sql (such as mysql) [http://troels.arvin.dk/db/rdbms/#functions-concat do not support this syntax]. --[[User:Rdm|Rdm]] 19:28, 16 November 2010 (UTC) |
||
::: Stick with the ANSI standard; the deviants can have their own entries (or at least their own sub-solution). –[[User:Dkf|Donal Fellows]] 23:40, 16 November 2010 (UTC) |
::: Stick with the ANSI standard; the deviants can have their own entries (or at least their own sub-solution). –[[User:Dkf|Donal Fellows]] 23:40, 16 November 2010 (UTC) |
||
== REXX || == |
== REXX || == |