The differences between Store Procedure and Function

Store Procedure: A stored procedure is a pre-compiled group of Transact-SQL statements .We can say a storedprocedure is a prepared SQL code that we save so that we can reuse the code over and over again.  If a repetitive T-SQL task has to be executed within an application, then the best way for it is to create stored procedure.  It is always recommended to create Stored Procedure instead of … Continue reading The differences between Store Procedure and Function

Advertisements