Arthur Fuller
artful at rogers.com
Thu Jun 24 14:56:52 CDT 2004
Exactly, with the small exception that Access stored queries can invoke Access UDFs... Which may require serious rethinking to get the same behaviour in views. Alternatively, you can write SQL UDFs which return tables, and then you can do anything you want with said return values (tables), such as join. Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, June 11, 2004 7:39 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Difference between views and queries I think the answer to my question is that views ARE what we in Access think of as stored queries. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence (AccessD) Sent: Thursday, June 10, 2004 3:07 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Difference between views and queries Hi John: Personally, I see little reason to run views as their creation is spawned at the server side and any hit on the server I try to avoid. The concept of distributive computing has always appealed to me. Queries, run at the client side. There might be better performance with views, if there are limited people accessing the server. Views limit, not that the client can see it anyway, access to/display of the real table and present a pseudo table. Security? HTH Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of jwcolby Sent: Thursday, June 10, 2004 9:33 AM To: SQLServer Subject: [dba-SQLServer] Difference between views and queries Can anyone explain the difference between a view and a query? Views use a query, plus the view keyword. I have a couple of books that I have read the chapter on Views, but I so far haven't managed to "get" why you wouldn't just use the query itself instead of turning it into a view. John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com