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

Do you know what are the restrictions that views have to follow?

1069

How can we improve performance by using SQL Server profiler?

1047

What is log cache in sql server?

1026

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

952

Can sql servers link to other servers like oracle?

833

Explain the advantages of merge replication?

942

Explain throw statement in sql server 2008?

975

Define tempdb database?

984

Explain the difference between HTTP and HTTPS in database?

1022

How to send email from database?

1006

What is change data capture (cdc) feature?

1048

What is store procedure?

1047

What the different topologies in which replication can be configured?

1080

Can you explain powershell included in sql server 2008?

928

How will you add a dimension to cube? : sql server analysis services, ssas

1067