What is the different between Stored Procedure and Procedure?
Answer Posted / rasmita basantia
if we are writing a procedure with create or replace
syntax ,then its a procedure.if its compiled and stored in
the data base then its called stored procedure.
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is dml and ddl?
what is schema? : Sql dba
What is normalisation in sql?
What is the difference between local variables and global variables?
What is the maximum number of triggers, you can apply on a single table?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What are the differences between in and exists clause?
What is difference between mysql and postgresql?
What is the source code of a program?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Which join is like inner join?
Why is there a need for sqlcode and sqlerrm variables?
Does sql backup shrink transaction log?
What is normalization in sql?
what are the advantages and disadvantages of cascading style sheets? : Sql dba