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 ?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please tell us what is the difference between override and overload in a method?

791


Is there built-in support for tracing?

798


If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

744


Explain clr, cts and cls?

846


When should I use .net core?

800


What is .net3.0 and .net3.5?

762


Tell us what is a sealed class?

764


Explain how garbage collection works?

780


Differences between dll and exe?

834


What does msil do?

769


What is UDDI and how to register the web service in it?

815


Define marshling?

790


What is reflection in microsoft .net context?

754


What is "common language specification" (cls) in .net?

750


When a Static Constructor called in .NET?

784