What do you used to write in the Stored procedure header ?

Stored procedure header plays a crucial role in providing the information to the developer to understand the description and history of it. I usually write: Stored procedure name Stored procedure description Created/modified date time Databases used Tables used Change request ID Change description

Read More

When do we use UDFs instead of Stored Procedures?

Since there are more advantages of Stored procedures over UDFs, most of us think that stored procedures are the best always. There should be some reasons why UDFs were introduced in DBMS. Below are the scenarios in which we should use UDFs

Read More

What are the types of Stored Procedures available in SQL Server?

Types: User-defined Temporary Local Global System Extended user-defined Note: These types might change over the SQL Server versions changes. The above types are based on SQL Server 2016. Click here for the more information. Happy Reading   

Read More

Why do we use Stored Procedures?

There are lot of Advantages of creating a stored procedure instead of running DB scripts individually. Below are the major reasons which tell us why we use stored procedures in DB. The Best feature of stored procedures is, compile once and execute

Read More