What is the difference between View and stored procedure?

A

addd2015-12-01 11:10:38

SQL Server

addd, 2015-12-01 11:10:38

What advantages does View have that are not in stored procedure in mssql?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Alexander, 2015-12-01
@NeiroNx

The View is supposed to return data. And procedure is not obliged to return them.

A

Artyom Karetnikov, 2015-12-02
@art_karetnikov

The only advantage of the view is that you can join with it. Otherwise, it has no advantages, but there are disadvantages, especially if a not very experienced developer starts joining with it.
I highly recommend using the procedures wherever possible. For a GUI developer, this is a black box, he knows the call parameters and return values, but what is inside is not. It's the same for the user.
It will be precompiled, any beauty can be made inside it... Storks are our everything.