State some Uses of function.

669    Asked by JosephSlater in SQL Server , Asked on Dec 16, 2019
Answered by Rachit Gupta

Below are few uses:

1. Function is written only once and can be used/called multiple times at multiple places such as procedure/ views etc. this saves further efforts and time

2. It helps in making the program modular and easy to understand

3. Functions are compiled once and there are cached before they are used.

4. It helps in improving the performance and efficiency of the database

5. We can break down the complex logic into smaller and simpler functions as it allows us to use function inside a function.

6. Functions are easier to understand and maintain.


Your Answer

Interviews

Parent Categories