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

Can we write trigger for view?

571

What is the difference between value type and reference type?

565

How many database files are there in sql server 2000?what are they?

589

What are 3 ways to get a count of the number of records in a table?

621

Explain forward - only cursors?

531

what are the different types of SSRS reports?

112

What is the use of commit?

557

What is difference between cte and view?

532

What is instead of trigger sql server?

510

What is the concept of optimization?

581

What is the use of RDBMS?

598

What are “phantom rows”?

1257

What is the synonym of join?

535

How to check parameter value in stored procedure sql server?

480

What is the web service used for reporting services?