Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / raghuram
Stored procedure is a set of T-Sql statements combined to
perform a single task of multiple tasks. It do not run
values, It performs only tasks. It reduces network traffic
and improve the performance. It accepts the input
parameters. It helps to ensure the integrity of the
database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you size a resultset?
Explain system rowset functions?
Tell me what do we need queues in sql service broker?
What is a field name?
What is scrollable cursor?
Do you know exporting and importing utility?
What to perform pattern match with the like operator?
What do you understand by the denormalisation?
What is the recursive stored procedure in sql server?
How to get the query of a table in sql server?
how many no of arguments can be passed in procedures and functions
What type of Index will get created after executing the above statement?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are the properties of the transaction?
