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

How to update muliple row in single query?

1046

Why use identity in sql server?

1086

What is difference between count (*) and count 1?

919

How to create a testing table with test data in ms sql server?

1074

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1084

Explain what is the function of sql server agent windows service?

986

When is the use of update_statistics command?

994

What is difference between sql and sql server?

986

What do you mean by stored techniques? How would we use it?

1022

What is the use of set nocount on/off statement?

1087

What is the difference between lock, block and deadlock? : sql server database administration

1033

Write a sql query to display the current date?

1084

What is difference between group by and having?

939

What are window functions in sql server?

998

how many clustered indexes can be created on a table? : Sql server database administration

1138