Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
Advantages of using stored procedures :
Stored Procedures
stored procedures is the collection of Sql statements which is stored in data base .
below are the advantage of stored procedures :
1.stored procedures reducing network traffic and boost application performance. .
...
How to Work with a Stored Procedure
How to Work with a Stored Procedure
DELIMITER //
CREATE PROCEDURE `p2` ()
LANGUAGE SQL
DETERMINISTIC
SQL SECURITY DEFINER
COMMENT 'A procedure'
BEGIN
SELECT 'Hello World !';
END//
The four characteristics of a procedure are:...
How to work on Stored Procedure in SQL
Store Procedure:-- These are set of SQL Statements which are grouped in such a way that they execute to do a certain task and make processing of our application fast.
Advantages:- They are stored in precompiled format and therefore are fast.
...