Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of grouping data in a report?
What is onf in normalization form?
In what version of sql server were synonyms released?
How do you improve the performance of a SQL Azure Database?
what are the core components of SSRS?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is #temp and @table variable in SQL server?
Explain what is row_number function?
How to create a store procedure with encryption?
What is the difference between mysql and sql server?
Is null in sql server?
Explain Geometry datatype in sql server 2008 with example
How do I start sql server 2017?
What are scalar functions?
Explain how you can configure a running aggregate in SSRS?