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
Do you know what is lock escalation?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is bcnf normalization form?
How to configure and test odbc dsn settings?
How to create user messages with print statements in ms sql server?
When we should use and scope of @@identity?
What is the index requirement in SQL Azure?
What are the dmvs?
How many categories of data types used by sql server?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Can a rule be bound to any column of any data type?
How to make conditional sum in ssrs?
What is the difference between lock, block and deadlock? : sql server database administration
How do you know if sql server is running on your local system?
Where is my database stored on the hard disk in ms sql server?
