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

Do you know what is rank function?

1071

What is the use of keyword with encryption.

1024

How to throw custom exception in Stored Procedure?

1038

How to create stored procedures with parameters in ms sql server?

1065

Differentiate between ms sql server reporting services vs crystal reports?

893

What are the properties of sub-query?

1063

What guidelines should be followed to help minimize deadlocks?

936

What are the purposes and advantages stored procedure?

948

What is the syntax to execute the sys.dm_db_missing_index_details?

1012

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1022

What do you understand by recursive stored procedures?

982

What is trace flag in sql server?

1011

Do you think BCNF is better than 2NF & 3NF? Why?

1272

What are the advantages of policy management?

993

When would you prefer to have a minimum number of indexes?

895