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

Where cross join is used?

969

Why I can not enter 0.001 second in date and time literals in ms sql server?

1069

What is subquery? Explain the properties of a subquery?

991

What are subqueries in sql server? Explain its properties.

1025

What are the basic features of a trigger in ms sql server?

1202

Describe the left outer join & right outer join. : sql server database administration

999

What are subqueries in sql server?

1130

what is a mixed extent? : Sql server administration

1111

How to concatenate two strings in SQL Server.

1153

What is the current pricing model of SQL Azure?

104

What do you mean by sql server 2005 express management tools?

1316

Differentiate between ms sql server reporting services vs crystal reports?

914

What are commit and rollback in sql?

1135

How do I setup a local sql server database?

1012

Can I run multiple instances of sql server 2000 at the same time on one computer?

1076