...
Rel also looked interesting, and I liked some of the syntax -
especially the fact that for relvar datatypes, A + B is the union of A
and B, and hence A += B is an insert, etc.
I think it's more than syntax, TTM defines it that way.
.
Re: Not Common both Tables ... For exemple, I'm sure that the Full Outer Join is not available under ... I'm pretty sure that the Exitsstatement and the UNION... For the syntax error, it's probably a missing AND in the first subquery of ... You can also use an Outer Join and select all the records which will have ... (microsoft.public.access.adp.sqlserver)
Re: Management Studio & Views containing unions ...display the View, which I guess is OK, the old tool couldn't do that ... the syntax verification doesn't work either.. ... "Incorrect Syntax near UNION" error each time. ... Why does MSE choke on a union even if the query is valid? ... (microsoft.public.sqlserver.tools)
Re: retrieving top 1 of ordered union ...Syntax is not your problem. ... You think that SQL's UNION is the same ... 1NF and make it look like a tape file.... Please post DDL, so that people do not have to guess what the keys, ... (microsoft.public.sqlserver.programming)
Management Studio & Views containing unions ... editing Views that contain a UNION statement.... For starters, it can't display... I get an "Incorrect Syntax... Why does MSE choke on a union even if the query is valid? ... (microsoft.public.sqlserver.tools)
Re: How difficult is ada to learn? ... >> syntax is far less elegant and readable. ... but Ada 2005 will have a set container type.... > supports union, intersection, etc. ... (comp.lang.ada)
