Posted by onedaywhen on 01/05/07 15:55

On Jan 4, 3:35 pm, "--CELKO--" <jcelko...@earthlink.net> wrote:
> VIEWs can be built on VIEWs, so
> you need to commit the first VIEW to do this.
>
> That also means you cannot end it with a semi-colon and have to have a
> keyword GO instead.

FWIW in SQL Server 2005 you can end a CREATE VIEW with a semi-colon but
it must still be "the first statement in a query batch".

Jamie.

--

[Back to original message]