Warning: mysqli_real_connect(): Headers and client library minor version mismatch. Headers:50562 Library:30312 in /home/seotoolh/public_html/memorypointer.com/wp-includes/class-wpdb.php on line 1982
Difference between Stored Procedures and Views | MemoryPointer.com

Difference between Stored Procedures and Views

0

Here are some of the differences between stored procedures and views

Stored Procedures

  • Can accept parameters
  • Can contain multiple statements (Select, insert, update, delete, loops, if else etc)
  • Can perform modifications to tables
  • Cannot use stored procedures in joins

Views

  • Cannot accept parameters
  • Have single select statement
  • Cannot perform modifications to tables
  • Views can be used in joins

Get Free Email Updates!

Signup now and receive free offers, discounts & coupon codes

I agree to have my personal information transfered to Mad Mimi ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge

This site uses Akismet to reduce spam. Learn how your comment data is processed.