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

Compare a temporary table and a variable table

The debate whether to use temp tables or variable tables is an old debate and we usually ask which one is better and when we use temp tables or variable tables . In this article, I will show you the differences between the two and I hop you will have the appropriate approach in your … Continue reading Compare a temporary table and a variable table