Re: SQL2011 and writeable CTE

2010/11/8 Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>:
> 2010/11/9 Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>:
>> 2010/11/8 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
>>> 2010/11/8 Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>:
>>
>>>> Hmm, this looks very different from our writeable CTEs. And I can see
>>>> many issues like syntax ambiguity and execution order if we support
>>>> it. AFAIK the most significant reason why we are working on CTEs is
>>>> that CTEs are regarded as something like materialized table.
>>>>
>>>> So I think we are going on writeable "CTEs" unless there are no
>>>> objection rather than pursuing the standard.
>>>> Thanks for sharing anyway.
>>>>
>>>
>>> I found, so writeable CTE was implemented in Microsoft SQL server too.
>>> Can be our implementation compatible?
>>>
>>
>> I don't believe MS SQL Server doesn't implement such our writeable
>
> I mean, "I don't believe it implements..." :)

ook :)

Pavel

>
> --
> Hitoshi Harada
>