Programming, Graphics Resources & Reviews

Programming Related Technology Blog

SQL Server

Difference between Stored Procedures and Views

Byadmin

Feb 15, 2013

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.

Related Posts

By admin

Related Post

SQL Server

Rounding a number to 2 decimal places in SQL SERVER

Feb 16, 2013 admin
SQL Server

Formatting DateTime to Date in SQL SERVER

Feb 16, 2013 admin
SQL Server

Finding duplicates with SQL?

Feb 15, 2013 admin

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.

You missed

Other

Replace SQL Server new line with HTML

Sep 9, 2021 zeeshan
Templates Wordpress

15+ Top Mobile Themes For WordPress

Dec 4, 2017 admin
Javascript Templates Wordpress

17 Of The Best Rated Angular 2 Website Templates

Nov 28, 2017 admin
Templates

The 16 Best Responsive AngularJS Templates?

Nov 27, 2017 zeeshan