----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: Star_Venkat Message 1 in Discussion Information about Views: Wish to add some more guidelines to the existing ideas in creating the views, 1. 'CREATE VIEW' must be the first statement in a query batch. If we try to execute the below batch query an exception will be thrown indicating create view statement should be the first. [code] Create table msdn(idval int) Select * from msdn Create view msdnview as select * from msdn [/code] 2. "Create view" statement cannot be used in Stored procedure. Try to creat a view inside a stored procedure, [code] Create proc NewProc as begin Create view msdnview as select * from msdnTable end [/code] 3. You can create a view on another view [code] create view vview1 as select * from vview [/code] Regards, Venkatesan Prabu. J ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
