Posted by Dan Guzman on 01/04/07 12:16

You can include GO batch delimiter following each CREATE VIEW statement.
Tools like OSQL, SQLCMD, SSMS and Query Analyzer send the preceding batch of
SQL statements whenever a GO is encountered.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Siddu" <siddu.roy@gmail.com> wrote in message
news:1167892621.237538.321780@31g2000cwt.googlegroups.com...
> Hi All,
>
> I am new to this group and this is my first doubt i am facing at
> present.
>
>
> I am doing data migration. In this sequence i need to alter few views.
> Alter in the sense, inside the existing query of view i want to include
> one more column.
>
> I want to do it inside one single script. If i run the script all views
> should get updated.
>
> Any help on this will be greatful.
>
>
> my mail id is siddu.roy@gmail.com.
>
> Thanks in advance
>

[Back to original message]