Re: Views vs Stored Procedures, whats the difference?

create a view.

then create that same view "into" a stored procedure.

everything you can do in a view you can do in a stored procedure. But
in a stored procedure, you can do MUCH more, much faster, and with much
more flexibility.

And then, you can do a whole lot more then that with a stored
procedure. Think of a view as memorizing key strokes for an old time
macro.

Think of a stored procedure as a full fledged programming language.

.

Relevant Pages

  • MailMerge DataSource problem
    ... I have a DOT template which runs a ... In the macro, I have an ADO connection to get my ... because the stored procedure is probably not returning ...
    (microsoft.public.word.mailmerge.fields)
  • run time error 2147217900
    ... I have a macro that runs a sql stored procedure and brings ... back a record set. ... It doesn't matter which stored procedure I'm ...
    (microsoft.public.excel.programming)
  • Send SMTP Mail from a Macro/Stored Procedure
    ... I would like to be able call SMTP from a macro or stored procedure that ... different based on selected data in a recordset and where I could ...
    (comp.sys.ncr)
  • Re: Can I return multiple tables using Access 2000?
    ... I don't know if you can use the macro from oleDataAdapter, ... to call a macro instead of a stored procedure ... >> column datatypes in the same order, you could build a union of them ...
    (microsoft.public.access.queries)
  • run time error 2147217900
    ... >back a record set. ... >choose end, and try the macro for the 3rd time, it works ... It doesn't matter which stored procedure I'm ...
    (microsoft.public.excel.programming)