Re: Stored procedures vs. views for filling record sources

That depends on your requirements.

A stored procedure is generally more secure, and will perform better because
of caching etc, but a view can be selected from (e.g. SELECT SomeCol FROM
SomeView). You can also use UDF's which are cached like sp's, but can be
selected from.

Views do not support parameters, sp's and UDFs do.

Depening on requirements, I often use Views for updateable recordsets
because they are normally easier to bind and modify etc, but for read-only
recordsets I normally try to use SP's.

Outside of Access, where updates/inserts etc have to be written I always
prefer to use SP's.


"Andy G" <ajgould@xxxxxxxxxxx> wrote in message
news:OuxqTJO1FHA.560@xxxxxxxxxxxxxxxxxxxxxxx
> Should I use a stored procedure or a view when filling a record source in
> an .adp?
>
>
>


.

Relevant Pages

  • How to you page and sort large dataset result in datagrid?
    ... Is there a good way to page/sort VERY large Result set in datagrid ... " Here's a stored procedure that I use for sorting and paging large ... or even thousands, of records, but working with larger recordsets with ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Ado Recordset and stored procedure(SQL server 2000)
    ... I want to fill a recordset using a stored procedure. ... The problem is that your stored procedure is returning multiple ... statements from generating empty recordsets. ... avoid naming your stored procedures with "sp_" as a prefix, ...
    (microsoft.public.vb.database.ado)
  • Re: Timeout problem
    ... This stored procedure retrieves 4 recordsets, one of the recordset is about 3k raws. ... It does look like the timeout happens during increased users activity on the SQL server. ... > there anything we can do to increase timeout period without modifying source ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OLE error 80040200 when assigning events of a TCustomADODatasetpointingto a multi-select stored
    ... > recordsets will inherit properties. ... characteristics of the stored procedure that is causing the multiple ... declare @Temp int ...
    (borland.public.delphi.database.ado)
Loading