A Store Procedure is a Sql Inquiry that is shops in database in Sql Server. Something is that there is no requirement to quiz to be compose on front end code. Utilizing shop treatment improves performance now the question occur just how its boost efficiency. Lets expect we need to place some pick inquiry (choose * from dotnetquestion where id1000 and id5000).

Here dotnetquestion is table and 1000 customer are using this query at the same…