Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 ?

Answers were Sorted based on User's Feedback



what is the use of stored procedure which has only one select statement over simple select statmen..

Answer / ravinder kumar

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

what is the use of stored procedure which has only one select statement over simple select statmen..

Answer / rkasha

SP are better than SQL Query, but UDF (User Defined
Function) are even beter. Since it can be called in any
query and will return multiple records

Is This Answer Correct ?    0 Yes 0 No

what is the use of stored procedure which has only one select statement over simple select statmen..

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

Post New Answer



More Dot Net General Interview Questions

What is the difference between encrypting a password and applying a hashing?

0 Answers  


Please explain what is the .net framework and how does it work?

0 Answers  


What is typical about a windows process in regards to memory allocation in dot net?

0 Answers  


When we use windows api in .net is it managed or unmanaged code?

0 Answers  


What is the use of activex control in .net?

0 Answers  






What is the difference between vb.net and vc#.net?

0 Answers  


What is implement a generic action in webapi?

0 Answers  


What is the use com component in .net?

0 Answers  


Explain me what is .net web service?

0 Answers  


What are the providers available with VS.NET ?

2 Answers   TCS,


What class does icon derive from? Isn't it just a bitmap with a wrapper name around it?

0 Answers  


What is UDDI and how to register a web service ?

2 Answers   Msoft, TCS,






Categories