Results 1 to 8 of 8

Thread: Can we use procedures within Views

  1. #1

    Can we use procedures within Views

    Hi Friends,

    Can you just tell me that Can we use procedures within Views? Can you just tell me as soon as possible


  2. #2
    Contributing Member
    Join Date
    Apr 2007
    Answers
    46

    Re: Can we use procedures within Views

    ya we can use view in procedures


  3. #3
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: Can we use procedures within Views

    I know that I am replying after two weeks. If you have not find answer till now then this may help you.

    You can use procedures with in view definitions.


  4. #4
    Junior Member
    Join Date
    Jul 2007
    Answers
    7

    Re: Can we use procedures within Views

    Views are simply pre-defined SELECT statements against tables in your data model. They are primarily used for simplification of data presentation and to secure your data by only exposing those columns the user needs to see. Views do not store any data (the exception is Indexed Views, which do) but are treated by SQL Server like actual tables

    so, i dont thik so....it possible


  5. #5
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Can we use procedures within Views

    procedures can't be used with in view definitions.

    You can use functions if you want.


  6. #6
    Junior Member
    Join Date
    Sep 2007
    Answers
    1

    Re: Can we use procedures within Views

    [QUOTE=Subashini.Ramasamy;13009]Hi Friends,

    no we cant use


  7. #7
    Junior Member
    Join Date
    Jan 2008
    Answers
    3

    Re: Can we use procedures within Views

    we can't use a procedure within a view ....view can be used within a procedure...


  8. #8

    Re: Can we use procedures within Views

    Yes you can call a procedure inside a view by following the scenario.

    create a procedure or function which would return a ref cursor as an out parameter.

    if the name of the procedure is xyz

    then create a view with the select statement as
    select * from table(xyz)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact