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
- 7015 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 |
Explain what is the difference between encrypting a password and applying a hashing?
When displaying fonts, what is the difference between pixels, points and ems?
What property do you have to set to tell the grid which page to go to when using the Pager object?
What are Sessions?
How will you do redo and undo in textbox control?
Can you write a class without specifying namespace?
How boxing and unboxing occures in memory?
What is .net3.5?
What is the reason of occurring overflow-underflow arithmetic exception error, it shows error message when we run our program by adding control?
Explain the features that are common to all .Net languages.
How to get the number after decimal point in .net?
i have 2 functions, int add(int a,int b); double add(int a,int b); does this code implement overloading? if not what will be the error?
Dot Net Framework 
