what is the use of stored procedure which has only one select statement over s

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 ?

Question Posted / shirishakyatoor

3 Answers
7179 Views
I also Faced
E-Mail Answers

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 a class and an object, and how do these terms relate to each other?

0 Answers

Explain what do the terms “boxing” and “unboxing” mean?

0 Answers

Sql Queries: A Table will be given Omiting Duplicate rows and adding a new column

0 Answers

What is Atomicity?

3 Answers Verifone,

Explain dataset.acceptchanges and dataadapter.update methods in .net?

0 Answers

I am looking for a fast track course (MAX 15 days) in MS.NET 3.5 and SQLSERVER 2005 in hyderabad or mumbai or pune. I am working in mumbai so cannot gor for long course. Can any body suggest me the best couching class or best faculty for the same. Thanks.

2 Answers

Explain garbage collection?

0 Answers

What are the collections you've used?

0 Answers

What is an Exception? How many exceptions exist in Dot net and explain them?

2 Answers CSC, TCS,

Define satelite assembly?

0 Answers

What is use of ContextUtil class?

1 Answers

What is the microsoft .net?

0 Answers

For more Dot Net General Interview Questions Click Here