Interested to Buy Any Domain ? << Click Here >> for more details...
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 bit data type? What's the information that can be stored inside a bit column?
What stored by the msdb? : sql server database administration
What are the advantages of using stored procedures?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How to get the query of a table in sql server?
How do you rename a table in sql server?
Write the syntax for stuff function in an sql server?
When columns are added to existing tables, what do they initially contain?
What is data compression?
Is it important for a database administrator to understand the operating system and file access?
Which language is supported by sql server?
What is the purpose of floor function?
Can a function call a stored procedure in sql server?
how to control the amount of free space in your index pages? : Sql server database administration
What are the new features of sql server 2012 reporting service?
