function cant return Result set where procedure can

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

Question Posted / tarun waia

Answer Posted / tarun waia

function cant return Result set where
procedure can

Is This Answer Correct ?

17 Yes

45 No

Please Help Members By Posting Answers For Below Questions

What is SQL Azure Fabric?

108

Explain what is the main purpose of having conversation group?

880

What are the events recorded in a transaction log?

929

What is standby servers? Explain types of standby servers.

930

What are the different types of columns types constraints in the sql server?

1008

What is the maximum row of a size?

953

Explain left outer join and right outer join?

972

A trigger can reference objects outside the current database? State true or false.

945

What are the 7 disadvantages to a manual system?

907

What are the types of processing and explain each? : sql server analysis services, ssas

1105

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1548

Explain cursor as data base object?

974

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1017

How to create sub reports?

226

Why do we use functions?

856