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

How many types of transactions are there in com + .net ?

563


SAP Business One(this is intigrated tool of .net)

1768


What are the new 2.0 features useful for?

613


What is a formatter in .net?

564


How to get the number after decimal point in .net?

559






Explain what rare the types of jit and what is econo-jit?

508


What is the difference between constants and read-only variables?

533


What is equivalent for regsvr32 exe in .net ?

664


What is garbage collection and how it works. Provide a code example of how you can enforce garbage collection in .net?

504


How to view a .NET assembly?

593


Which namespace does it belong to by default?

561


Explain Different kinds of methods?

1629


Which namespace is used to support multithearding in .NET?

515


What are the main components in .net?

517


What is implement a generic action in webapi?

707