Similarity is SP & View both can return the data from tables and both hide the database structure from the user and provide the security.
Differences
Ø SP can be parameterized whereas views can not be.
Ø Views can be indexed, Stored Procedures can not be.
Ø Stored Procedures are better than views in performance, particularly on large tables.
No comments:
Post a Comment