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
- 7043 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 |
What is the reason of occurring overflow-underflow arithmetic exception error, it shows error message when we run our program by adding control?
Is there any inbuilt tool or command provided by .NET to view the code inside the assembly?
Explain the Scope of public/private/friend/protected/protected friend.
How we can achieve Connection pooling in .Net?
Which property is used in the email to send the content as HTML
How to get the number after decimal point in .net?
Please explain what is the difference between odbc and ado?
How many types of transactions are there in com + .net ?
Give an example program for Getter /read-only methods in JAVA
Explain the difference between public and static modifiers?
Tell me what is serialization?
What is strong name?
Dot Net Framework 
