SQL----best one

Question

which is the best one in stored procedure and view? stored procedure can return value?

Jiteendra Sampathirao · Answer

1. Functions are used for doing computations and SP's are for performing business logic. 2. Function must return a value but in SP's its an optional. 3. Function parameters are always IN no OUT parameters is possible. 4. Using Stored Procedure we can handle number of queries(Insert update delete )........ Refer this link to know abt SP's: http://www.c-sharpcorner.com/UploadFile/jitendra1987/3848/Default.aspx?ArticleID=274124a2-1c6a-45fb-8ba4-c459c2fbf223 If this post helped you then tick the  Do you like this Answer  checkbox which is placed at above this post.

Suthish Nair · Answer

Should I use a view a stored procedure or a user-defined function?

Jiteendra Sampathirao · Answer

Hi we cannot say which is the best one. Stored procedure is a precompiled execution statement. So it reduce the traffic. There are 3 types of procedure. 1) in parameter 2) out parameter 3) in/out parameter View is a virtual table. View is derive from base table.if we delete base table view also automatically will delete. There are 2 types of view 1) Simple view. 2) Complex view. We can get the return value from Stored Procedure. If this post helped you then tick the  Do you like this Answer  checkbox which is placed at above this post.