Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6881 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / hardik
execution of the stored procedure is faster than simple sql
statement query.
for e.g.
select * from tablename is simple sql statement
create proc temp
as
begin
select * from tablename
end
above is sp of that statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why do we use msmq?
Tell me what is serialization?
What is an exe and a dll?
What is meant by localization?
you have a requirement from client, he has an XML file and you need to insert the data into 5-6 tables in database. explain me the procedure.
What security measures exist for .NET Remoting in System.Runtime.Remoting?
What is the intermediate language between asp and asp.net1.0?
What does cil do?
How will you do redo and undo in textbox control?
What is meant by globalization and localization?
What is garbage collection in .net? Explain the garbage collection process?
What is dot net architecture?
Dot Net Framework 
