what is the use of stored procedure which has only one
select statement over simple select statment query ? Why to
write a stored procedure then ?
- 3 Answers
- 6373 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravinder kumar
Because stored procedure are pre compiled and need not to
compile again .it is faster than simple query.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is 'Common Type System' (CTS) in .NET?
Explain dataset.acceptchanges and dataadapter.update methods in .net?
What is the single responsibility principle?
Explain the top .net class that everything is derived from?
What is implement a generic action in webapi?
Explain can 2 different applications use the same dll in gac at the same time?
I want to serialize instances of my class. Should I use xmlserializer, soapformatter or binaryformatter?
What is .net environment?
How to implement datagrid in.net? How would you make a combo-box appear in one column of a datagrid? What are the ways to show data grid inside a data grid for a master details type of tables? If we write any code for datagrid methods. What is the access specifier used for that methods in the code behind file and why?
What is stored procedure ? how we use it in .NET ?
How does the generational garbage collector in the .net clr manage object lifetime? What is non-deterministic finalization?
Is there any thread in our .net programs?
Is .net core stable?
What is a design pattern and what is it for?
Is there any inbuilt tool or command provided by .NET to view the code inside the assembly?
