When would you use the stored procedures or functions?

devquora
devquora

Posted On: Feb 22, 2018

 

As we all know, functions are the computed values and they cannot perform any permanent environmental changes to the SQL server. Neither insertion in the statement is allowed nor can it be updated. If a function returns a scalar value or can be joined upon if it returns a scalar set, then it can be used inline in the SQL statements. These are used when the logic applied in the application is centralized and the data is stored in the application. These stored procedures are used when we need to validate the data and the complex procedures.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Stored Procedures Interview Questions

    What do you understand by a stored procedure?

    The group of SQL statements which are or have been stored in the server database is known as a stored procedure. Input ..

    Stored Procedures Interview Questions

    Mention the uses of stored procedures.

    Stored procedures are used for various different things. Some of the uses of stored procedures are as follows:Stored p..

    Stored Procedures Interview Questions

    What are the types of stored procedures in an SQL server?

    The types of stored procedures present in an SQL server are listed as follows: – User-defined stored procedures– th..