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
How do you rename a table in sql server?
What is user-defined inline table-valued function?
Explain what is lock escalation?
How real and float literal values are rounded?
Why union all is faster than union?
Explain microsoft sql server functions?
How to count groups returned with the group by clause in ms sql server?
Explain how many normalization forms?
How many types of keys are there?
What happens if you are trying to access a schema not owned by you?
How to end a stored procedure properly in ms sql server?
what is nonclustered index
Explain what is scheduled job and how to create it?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is the default sql server instance name?
