Main difference between sp and function is we cannot use store procedure i

Differnce between Stored procedure and user defined functions?

Question Posted / ashok

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

Please Help Members By Posting Answers For Below Questions

What is microsoft ole db provider for sql server?

972

What are the uses of Stored Procedure?

1105

What is a column variable?

983

Describe briefly an ADO.NET Dataset ?

1168

What are the pre-requisites for connection pooling?

1054

What is a string variable?

971

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1174

What is the full form of ado?

1080

can we create synonymn in ms access,sql server,my sql if so explain me with example

2138

What is a dataview?

1030

How do you implement locking concept for dataset?

1040

What is the difference between oledb sql server and oledbdotnet provider?

1052

What are all the classes that are available in System.Data Namespace?

1062

What is difference between executenonquery and executequery?

1019

Compare Data Reader & Dataset in ado.net?

1044