Answer Posted / babu
stored procedure is PL SQL statement that is called by a name
procedure perform a task, they does not return value.
1.reduce network traffic
2.reduce server overhead
3. Excution plan may be reused
4.provide good security for our data
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain boyce and codd normal form(bcnf)?
Explain syntax for dropping triggers?
What is a constant or literal in ms sql server?
How can you check the level of fragmentation on a table?
What new data source types were added in ssrs 2014?
What is ssl in sql server?
What is subquery? Explain the properties of a subquery?
Does sql server 2000 full-text search support clustering?
How many columns can we include on clustered index ?
Where actually sql azure database is hosted?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is difference between count (*) and count 1?
How do you make a trace?
What is the difference between an index and a unique index?
what is datawarehouse?