What is the different between Stored Procedure and Procedure?

Answer Posted / v.v.s.vamshi krishna

In Procedures we give the functions and parameters to be
used instantly. this scenario goes similar to that of
instant food. This happens when the complexity is less. But
as far as the stored procedures are concerned they provide
much reusability and can complexity can be handled with
much ease.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many ways to get the current time? : Sql dba

520


how would concatenate strings in mysql? : Sql dba

560


What is the use of index in hive?

543


What are the various restrictions imposed on view in terms of dml?

513


Why we use cross join?

535






Which one is better subquery or joins?

549


what are different types of keys in sql?

600


how to extract a unit value from a date and time? : Sql dba

547


How many rows can sqlite handle?

576


What are some emotional triggers?

565


how to create a new table by selecting rows from another table in mysql? : Sql dba

551


Which sorts rows in sql?

577


What is replication id?

512


How to make a copy values from one column to another in sql?

565


Explain the the update statement in sql?

562