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
>

• Next in forum: Re: Merge Replication and Trigger Problem
• Prev in forum: MI5 Persecution: Eye Say, and Lord Gnome Answers
• Thread view: Re: Alter more than one view

[Reply to this message]