Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / hr@tgksolutions.com
A stored procedure is a precompiled collection of SQL statements stored in the database. It improves performance and security by reducing query execution time.
Example:
CREATE PROCEDURE GetUsers()
AS
BEGIN
SELECT * FROM Users;
END;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an example of translating a date into julian format?
What is data abstraction in sql?
What are the packages in pl sql?
When is the explicit cursor used ?
How many tables can a sql database have?
Can there be more than one function with a similar name in a pl/sql block?
What is t-sql? : Transact sql
describe mysql connection using mysql binary. : Sql dba
Can a key be both primary and foreign?
How do I run a program in pl sql?
How do I run a sql trace?
Can you select everything, but 1 or 2 fields, without writer's cramp?
what is the stuff function and how does it differ from the replace function? : Sql dba
Why stored procedure is better than query?
How to get unique records from a table?
