Differnce between Stored procedure and user defined functions?

Answer Posted / ashok

Main difference between sp and function is we cannot use
store procedure in select statement where as we can use
function in select statement.

Is This Answer Correct ?    32 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is partial class?

550


Which provider is used to connect ms access, oracle, etc…?

525


Explain how to pass multiple tables in datasets simultaneously?

495


How to find the given query is optimised one or not?

504


Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

592






Explain the difference between ado and ado.net?

505


Which method in OLEDBAdapter is used to populate dataset with records?

561


What are the key features of ado.net?

665


What are the Features and disadvantages of dataset

555


How to identify the controls which can be used for binding data?

547


What is the difference between Command and CommandBuilder object?

589


How would you connect to a database by using .NET?

475


How can we load multiple tables in to dataset?

571


Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

1636


How can I retrieve two tables of data at a time by using data reader?

511