Professional Web Applications Themes

When to use VIEWS instead of Stored Procedures - Microsoft SQL / MS SQL Server

>> In which cases should a VIEW be used instead of a Stored procedure? << They do two different things, but assuming that there is a problem which can be solved equally well either way, as a GROSS, GENERAL RULE, use the VIEW. VIEWs are portable, standard SQL; stored procedures are not. A VIEW can be used in other statements and is subject to optimization; stored procedures are not. --CELKO-- =========================== Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, datatypes, etc. in your schema are. *** Sent via Developersdex http://www.developersdex.com ...

  1. #1

    Default Re: When to use VIEWS instead of Stored Procedures

    >> In which cases should a VIEW be used instead of a Stored procedure?
    <<

    They do two different things, but assuming that there is a problem which
    can be solved equally well either way, as a GROSS, GENERAL RULE, use the
    VIEW.

    VIEWs are portable, standard SQL; stored procedures are not. A VIEW can
    be used in other statements and is subject to optimization; stored
    procedures are not.

    --CELKO--
    ===========================
    Please post DDL, so that people do not have to guess what the keys,
    constraints, Declarative Referential Integrity, datatypes, etc. in your
    schema are.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Joe Guest

  2. #2

    Default Re: When to use VIEWS instead of Stored Procedures

    >> VIEWs are portable, standard SQL; stored procedures are not. <<

    Are you sure? I thought, it became the part of the standard back in 95.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  3. #3

    Default Re: When to use VIEWS instead of Stored Procedures

    >> I thought, it [stored procedures] became the part of the standard
    back in 95. <<

    The SQL/PSM-96 is not part of SQL Server; T-SQL is still a proprietary
    and rather weak 4GL. The other vendors are just as bad for the most
    part, so I cannot even do a good anti-microsoft rant about it.

    --CELKO--
    ===========================
    Please post DDL, so that people do not have to guess what the keys,
    constraints, Declarative Referential Integrity, datatypes, etc. in your
    schema are.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Joe Guest

  4. #4

    Default Re: When to use VIEWS instead of Stored Procedures

    My take on this is hw you operate on/with the object:

    A stored proc is code. What do you do with code? Execute. That is it.

    A view is a table (looks to the one who it using it as a table). What do you do with a table? Run
    SELECT, INSERT UPDATE and DELETE statement against.

    In general, stored procedures has performance advantages because of the precompiled/cached plans
    nature. (OK, you can index views, but that is a rather advanced feature.)

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


    "Jakob Persson" <dk> wrote in message
    news:015801c3672f$b70f4160$gbl... 


    Tibor Guest

Similar Threads

  1. Stored Procedure or Views?
    By cfdyn in forum Coldfusion Database Access
    Replies: 1
    Last Post: November 12th, 01:05 PM
  2. Replies: 1
    Last Post: September 27th, 01:51 PM
  3. Stored Procedures
    By Vladi in forum Microsoft SQL / MS SQL Server
    Replies: 9
    Last Post: August 13th, 01:52 PM
  4. SQL-DMO and stored procedures
    By in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 24th, 02:46 PM
  5. create views from parameterized stored procedures
    By gregg durishan in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 8th, 05:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139