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 do you understand by a view? What does the with check option clause for a view do?

780

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

796

What do you mean by authentication modes in sql server?

774

how you can list all the tables in a database?

740

Difference between group by clause and having clause in SQL?

740

What are the database roles? : sql server security

728

Define master database?

736

What is the difference between ddl and dml?

784

How to create percentile function?

124

What are tables in sql server?

704

How to delete duplicate rows?

710

When we should use @@error?

706

Write a program to fetch first 10 records from a file?

760

What is read uncmmited?

791

How do I view a trc file?

684