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
- 7077 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 |
How can you instantiate a tuple?
Where?s Windows service database located?
Which dll is required to translate xml to sql in internet information server (iis)?
What is Delegate? Have ever used Delegates in your project.
What is a garbage collector?
How can we convert XML data into DataBase table IN .Net?
Explain what relationship is between a process, application domain, and application?
What are pdbs?
How can I tell if .net 3.5 is installed?
What is class library in .net
How can you assign an rgb color to a system.drawing.color object?
Explain what is the reason of occurring overflow-underflow arithmetic exception error, it shows error message when we run our program by adding control?
Dot Net Framework 
