Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database. A View can either have all the rows of a table or specific rows based on certain condition.
Question:what is the difference between view and Stored Procedure (view vs stored procedure) in sql?
Description:Need to know the difference between the two in terms of which should be used in what conditions, according to my current research similar operation can be achieved using any of them
Posted by: Junaid Aziz | Posted on: Jan 25, 2019