|
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.
--
Navigation:
[Reply to this message]
|