function can be written in select statement but stored procedure cannot be

Difference between Function and Procedure-in general?

Question Posted / rohan

Answer Posted / rohan

function can be written in select statement but stored
procedure cannot be written in a select statement

Is This Answer Correct ?

9 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are the main differences between #temp tables and @table variables and which one is preferred?

1083

Explain what is the purpose of sql profiler in sql server?

1074

what is the sql equivaent of the dataset relation object ?

2027

Tell me the difference between clustered and non-clustered index?

937

What is a matrix in ssrs?

153

Differentiate between delete and truncate.

1062

How do users use Report Builder with SQL Server data sources?

155

What stored by the master?

952

What action plan is preferred if sql server is not responding?

1103

What are parameterized reports?

200

What is trigger in salesforce?

983

What is 1nf 2nf?

1009

What is raid? : SQL Server Architecture

1176

what are the types of indexes? : Sql server database administration

1122

Explain filtered indexes benefits?

1000