----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: milindkul Message 2 in Discussion hi, views and stored procedures can not be compared. coz, views are virtual tables which will fetch the records from the tables depending on the select statement you are writing in it. if it has more than one table then you cannot use dml on a view but if there is only one table in view then you can use DML which will affect the original table. you can use these views for reporting purpose not for inserting or updating table. whereas stored procedures are sequece of dmls written in one place. when ever you execute a stored procedure all the dmls in it will execute. using select statement does not make any sensehere. you will use stored procedures wherever you need to shoot sequece of dmls. hope this clarifies your doubt.. if you need more info you can contact me. bye Vijay ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_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]
