Re: Views vs. Stored Procedures?

Article View: bit.databases.mssql-l

Article #2029

Back to bit.databases.mssql-l Previous Next

#2029

From: Joe Claborn
Date: Tue, 25 Apr 1995 00:00

18 lines
1050 bytes

Some of you gurus correct me if I'm wrong

A view is like a select with a 'hidden' where clause, so the SQL still
'runs' on a client.

A stored procedure 'runs' on the server.

Thus the stored procedure should be faster.

>     What is the difference between selecting records through a View and a
>     Stored Procedure?  It seems there are things that can be done with
>     either, but I'd like to use the one that would be easiest on the
>     server.
>
>     Thanks
>
>     Rick Treese, Senior Programmer
>     Goldman, Sachs & Co.

Technical Details

Message-ID: <abc25ed40602100484ed@[128.165.56.93]>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,8148927826965464
X-Google-Attributes: gidf6611,public
From: Joe Claborn <jclaborn@TEQUILA.LANL.GOV>
Subject: Re: Views vs. Stored Procedures?
Date: 1995/04/25
Message-ID: <abc25ed40602100484ed@[128.165.56.93]>
X-Deja-AN: 101647566
sender: Microsoft SQL Server Discussion List
comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
content-type: text/plain; charset="us-ascii"
mime-version: 1.0
newsgroups: bit.databases.mssql-l