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 command would you use to add a column to a table in sql server?

1232

What will be the maximum number of index per table?

951

What is an example of a primary key?

911

What is the difference between for xml raw and for xml auto?

974

How to create function with parameter in sql server?

1039

What is store procedure? When do you use?

870

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

951

How can delete duplicate records in cte in sql server?

910

Why would you use sql agent?

1212

Explain syntax for disabling triggers?

970

How to create user messages with print statements in ms sql server?

940

What are the two authentication modes in sql server?

1058

What is DCL?

978

Explain about system stored procedure?

969

Can an entity have two primary keys?

925