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 the different topologies in which replication can be configured?
Which command is used for user defined error messages?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How to replace given values with null using nullif()?
What are the options which must be set to allow the usage of optimistic models?
Explain multiserver query
Can two tables have the same primary key?
How can sql injection be stopped? : sql server security
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
can an order by clause be used in a creation of a view?
What is executereader?
Ways to improve the performance of a SQL Azure Database?
Explain for xml explicit mode?
What is database isolation in sql server? : sql server database administration
Tell me what are cursors and when they are useful?
