Interested to Buy Any Domain ? << Click Here >> for more details...
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
Which are the two editions in which SQL Azure database available?
How to find out what is the default collation in a database?
What is the process of normalising?
what is dbcc? : Sql server database administration
What are the requirements to use odbc connections in php scripts?
What is equi join with example?
What are types of storage modes? : sql server analysis services, ssas
Describe and explain about SQL native client?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is difference between foreign key and unique key?
How to encrypt Strored Procedure in SQL SERVER?
What is the default sql server instance name?
Can you explain powershell included in sql server 2008?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is normalization? Explain its different types?
