MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Advantage of Stored Procedures?

Published on 23 February 13
279
0
0
Stored Procedures are precompiled one.
it is the group of sql statements.
stored procedure like a application programming.
stored procedure is a fast one because it is already
precompiled.
stored procedure is the one is easy to maintain.

Simple store procedure . It's help to get familiar with syntax.

DELIMITER //
CREATE PROCEDURE procedure_name()
BEGIN
SELECT * FROM table_name;
END //
DELIMITER ;













Stored Procedures are precompiled one.
it is the group of sql statements.
stored procedure like a application programming.
stored procedure is a fast one because it is already
precompiled.
stored procedure is the one is easy to maintain.


Simple store procedure . It's help to get familiar with syntax.

DELIMITER //
CREATE PROCEDURE procedure_name()
BEGIN
SELECT * FROM table_name;
END //
DELIMITER ;


This blog is listed under Open Source and Data & Information Management Community

Related Posts:

MySQL

 
Post a Comment

Please notify me the replies via email.

Important:
  • We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
You may also be interested in
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top