| Back to Questions Page |
| Question |
Tell me about the best bug you ever found. |
Rank |
Answer Posted By |
|
Interview Question Submitted By :: Jethva_trupti |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer |
none  |
0 | Guest
|
| |
| |
| Question |
Difference between Function and Stored Procedure? |
Rank |
Answer Posted By |
|
Interview Question Submitted By :: Latha Sree |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer |
1. Function must returned a value,but stored procedure is
not necessorly returned value
2. A function can be used to calculations,but sp used to
solve a business logic
|
0 | SreyasMN
|
| |
| |
| Answer |
stored procedure when executed generates execution plan
once and next time when it is executed again it will use
the generated execution plan,it does not generate it again.
Function compiles from the beginning and prepares the trace
or execution each time it is called. |
0 | Madhu
|
| |
| |
|
|
| |
| Answer |
stored procedure is precompiled one but Function not( want
to compile each time) |
0 | Sumesh.tc
|
| |
| |
|
| |
|
Back to Questions Page |
To Refer this Site to Your Friends 
Site Map
