[WPSM_AC... READ MORE >>
IN parameter It is the default mode. It takes a parameter as input, such as an attribute. When we define it, the calling program has to pass an argument to the stored procedure. This parameter's value is always protected. OUT parameters It... READ MORE >>
A Stored procedure is a collection of pre-compiled SQL statements stored inside the database. A procedure always contains a name, parameter lists, and SQL statements. Stored Procedure increases the performance of the applications. Once stored... READ MORE >>
Views are virtual tables that do not store their own data but display all or a few rows of data stored in other tables. View helps to simplify the complex business logic written in the SQL queries to simple one. Syntax CREATE VIEW `view_name`... READ MORE >>
Recent Comments