Sub Programs in SQL SERVER

Sub Programs:

    It is a process of splitting a large application program into small modules or blocks.

    SQL Server supports to write a sub program based on the following concepts;

1. Stored Procedures
2. Stored Functions
3. Stored Triggers

Advantages of Sub programs:

1. Provides security
2. It improves performance
3. Reduces Network Traffic
4. Readability gets increases
5. Code Reusability
6. Error Detection and modification is quite easy
7. Extensibility - It will allow a user to increase or decrease the code.

Thanks
GSV