Answer Posted / vimal
Store procedure is a pre compiled code
it is doing single task of several task
it is used to reduce the execution time
if we want to call store procedure just we call its name
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What causes index fragmentation?
Define outer join?
What is the difference between clustered index and primary key?
What is primary key and example?
How can we rewrite sub-queries into simple select statements or with joins?
Give an example of SQL injection attack ?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What structure can you implement for the database to speed up table reads?
what are database files and filegroups? : Sql server database administration
What is raid, and how it can influence database performance?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is Federation Root Database?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is inner join? Explain with an example?
What are the different types of backups that exist?