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
How to run queries with sql server management studio express?
What is pivot and unpivot?
Does a sql server 2005 select statement require a from?
What are “lock” hints?
What are the steps to insert a table?
What will happen if a column containing char type data is changed to the nchar data type?
What is log in sql server?
How can I track the changes or identify the latest insert-update-delete from a table?
How to connect php with different port numbers?
What are various limitations of the views?
What are unicode character string data types in ms sql server?
How to return the date part only from a sql server datetime datatype?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
what is spatial nonclustered index
