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

How can you ensure that the database and sql server based application perform well?

1119

Name the different type of indexes in sql?

1012

Explain tablesample?

1037

What is the difference between TRUNCATE and DROP?

1187

What is a group function explain with an example?

1034

Why use “in” clause in sql server?

1119

how to do partition in sqlserver

2545

Write query to return all rows sql?

1109

How to use order by with union operators in ms sql server?

1063

What is auditing in sql server?

964

What does truncate do?

992

How to truncate the log in sql server 2012? : sql server database administration

1344

Which command is used for user defined error messages?

1103

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1112

Can you explain what is indexed view? How to create it?

947