SP are better than SQL Query, but UDF (User Defined Function) are even be

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 / rkasha

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced .NET component

2424

What is the root class in .net?

1090

How boxing and unboxing occures in memory?

1108

Explain when should you use .net web forms over asp.net mvc?

955

What is a formatter in .net?

993

Explain the process of serialization in .NET?

1048

What is the difference between a namespace and assembly name in .net?

951

Explain what is the difference between a class and an object?

1182

What are the improvements made in cas in .net 4.0?

910

What is WSDL? Explain its architecture?

1122

What is RPC? What is the use of it?

1099

What is connected and diconnected database ?

1009

What is garbage collection and how it works ?

998

Please explain what is reflection and what is it for?

898

Explain garbage collection?

923