Function return only one value where as procedure can more than

What are the differences between stored procedure and
functions in SQL Server 2000?

Question Posted / pss

Answer Posted / pss

Function return only one value where as procedure can more
than

Is This Answer Correct ?

58 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What Is Rdbms?

1094

What are the differences between sql server and mysql.

1041

What is relationship? What number of sorts of relationship are there?

1075

What do you mean by subquery?

1033

List the different types of collation sensitivities in sql server?

992

Explain what is scheduled job and how to create it?

909

What is sub-query in sql server? Explain its properties.

1047

What is bcp? When does it use?

883

Why do we use stored procedures in sql server?

904

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

1022

What is transaction server explicit transaction?

979

How do I edit a procedure in sql server?

907

List all the types of user-defined functions?

1012

What is the meaning of sql server?

946

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

992