Re: building sets in SQL92
From: --CELKO-- <joe.celko_at_trilogy.com>
Date: Sat, 21 Jul 2001 23:31:26 GMT
Message-ID: <7e67a7b3.0106181126.1c26c6ec_at_posting.google.com>
Date: Sat, 21 Jul 2001 23:31:26 GMT
Message-ID: <7e67a7b3.0106181126.1c26c6ec_at_posting.google.com>
In full SQL-92 you could write:
(VALUES ('Boston'), ('Atlanta'), ('Columbia')) AS Cities(city)name)
The VALUES() statement is now generalized (orthogonalized?) to create tables and not just single rows. Most products donot have this yet, so you might have to use UNION ALL to put the rows into your working table. Received on Sun Jul 22 2001 - 01:31:26 CEST