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

Explain what inheritance is, and why it's important?

725


How to Create and Consume a Web Service?

2996


What is STA in .NET?

866


Is the COM architecture same as .Net architecture? What is the difference between them (if at all there is)?

1786


What is the difference between imperative and interrogative code?

1825


Explain about .Net products?

858


Why SOAP is required?

959


What are Satellite Assemblies? How you will create this? How will you get the different language strings?

1793


Can a dll be changed to an exe?

835


What are the purposes of using .net?

865


Explain the differences between server-side code and client-side code.

788


Explain how to spawn a thread?

741


What's the use of system.diagnostics.process class in .net?

820


Explain about managed heap?

865


Explain assemblies in .net?

827