What is stored procedure in SQL..??
Answers were Sorted based on User's Feedback
Answer / ramesh babu kollu
In a database management system (DBMS), a stored procedure
is a set of Structured Query Language (SQL) statements with
an assigned name that's stored in the database in compiled
form so that it can be shared by a number of programs. The
use of stored procedures can be helpful in controlling
access to data (end-users may enter or change data but do
not write procedures), preserving data integrity
(information is entered in a consistent manner), and
improving productivity (statements in a stored procedure
only need to be written one time).
Is This Answer Correct ? | 9 Yes | 0 No |
Stored procedure is set of SQL statements
Is This Answer Correct ? | 0 Yes | 0 No |
What is create statement?
How is sql server used?
How to get the definition of a view out of the sql server?
Describe how to use linked server?
What are scheduled tasks in sql server?
Explain triggers?
How to add additional conditions in SQL?
How you can minimize the deadlock situation?
State a few properties of relational databases?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What does it mean to normalize a database and why would you do it?
Can you link only other SQL Servers or any database servers such as Oracle?