Stored procedures

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • salmamona
    New Member
    • Feb 2007
    • 1

    Stored procedures

    Hello all,
    I am developing a web base application using ASP.NET with C# and I am actually learning the languages at the same time.
    I have developed a databse with 10 tables. In thecase of stored procedures, should I write stored procedures for every table in my database.
    Thanks,
    Mona
  • Akhilesh1505
    New Member
    • Feb 2007
    • 17

    #2
    Originally posted by salmamona
    Hello all,
    I am developing a web base application using ASP.NET with C# and I am actually learning the languages at the same time.
    I have developed a databse with 10 tables. In thecase of stored procedures, should I write stored procedures for every table in my database.
    Thanks,
    Mona
    Stored procedures are not table specific, you can write any number of stored procedure in your database.

    Comment

    • dorinbogdan
      Recognized Expert Contributor
      • Feb 2007
      • 839

      #3
      It depends on project requirements if need stored procedures or not.
      Stored procedures are recommended for complex operations on one or more tables.

      Comment

      Working...