Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Cool Unanswered: Use of Stored Procedures as opposed to views.

    Hi there,

    I am converting a database from MS-Sql to My-SQL. (My application is an ASP website)

    The MS-SQL database currently makes extensive use of views.

    From what I understand, My-SQL currently doesn't support views. This obviously makes my conversion process very difficult.

    Someone suggested to me that I should investigate using Stored Procedures as opposed to views.

    a) Does MySQL support Stored Procedures ?

    b) Would it be possible to use Stored Procedures instead of Views ?

    c) If positive, would it mean major code changes to my ASP site to accomodate this ?

    Thanks for the help!



  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    A) Not yet
    B) Not yet
    C) Probably


  3. #3
    Join Date
    Jan 2004
    Europe, Finland, Helsinki
    Hi Steve!

    You should remember: a view is actually a predefined, stores SQL-query and whenever you make a new query against a view, the DBMS first merges these two queries. Now MySQL does't support this feature, so you had to by hand. It's a big job, but can be done.

    Cheers, Bill

Posting Permissions

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