Row Value Expressions
Wed, 03/04/2009 - 20:02 | 
hdanzl
Specify a value or list of values to construct a row value.
Syntax
<row value expression> ::= <explicit row value constructor>
|
<row value constructor element> [ { , <row value constructor element> }... ] |
|
| | | |
<contextually typed value specification> |
<default specification> ::= DEFAULT
|
<contextually typed row value constructor element> [ { , <contextually typed row value constructor element> }... ] |
Notes
| ♦ | Row value constructors with more than 1 row value element are only supported in the INSERT statement in NexusDB V3 SQL. |
Examples
1) The following example selects students from California and New York:
SELECT studentName, state
FROM students
WHERE state IN ( 'CA', 'NY' )
| 2) | The following example inserts two new rows into the documents table: |
INSERT into documents ( documentID, title )
VALUES ( NEWGUID, 'NexusDB main features' ), ( NEWGUID, 'NexusDB special features' )
Conformance
|
SQL:2003 standard |
- |
Core SQL |
Tags:
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
![[]](/support/modules/ubercart/uc_cart/images/bullet-arrow-up.gif "Expand cart block."){kind=icon}
| 1x | NexusDB AWE DLL (10 installations; binary) | AUD 1,950.00 |
| 1x | SLA - Gold (add years in quantity field) | AUD 3,600.00 |
| 2x | NexusDB Developer DCU Edition | AUD 1,170.00 |
| 1x | NexusDB AWE DLL (40 installations; binary) | AUD 6,400.00 |
| 2x | NexusDB PHP Connector | AUD 975.00 |
| 1x | NexusDB AWE DLL (100 installations; binary) | AUD 12,500.00 |
| 1x | NexusDB Developer Source Edition | AUD 890.00 |
| 1x | NexusDB AWE DLL (1 installation; binary) | AUD 330.00 |
| 1x | NexusDB Professional Edition | AUD 1,400.00 |
| 1x | NexusDB Embedded Source | AUD 430.00 |
| 1x | NexusDB Server License Plugin | AUD 250.00 |
| 1x | NexusDB Starter Edition DCU | AUD 150.00 |
| 14 Items | Total: AUD 30,045.00 |
| (View cart) (Checkout) | |
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm