SP return a single result-set, SP works with table variables, SP uses EXE

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

Question Posted / bhupi

Answer Posted / bhupi

SP return a single result-set,
SP works with table variables,
SP uses EXEC stmts

Is This Answer Correct ?

28 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of using stored procedures in sql server?

1006

What is rtm version in sql server?

1036

Define primary key?

1126

How do I find the sql server version?

1016

Why use view instead of a table?

936

What is temporary table in sql server? Why we use temp table?

941

What is the stuff and how does it differ from the replace function?

1117

What is usually the first word in a sql query?

1122

Explain the database you used in your final year project?

1030

Describe the functionalities that views support.

1091

What are the differences between ms sql server & oracle?

1050

How to set database to be read_only in ms sql server?

998

What are the requirements on sql server network connections?

964

What is t-sql script to take database offline – take database online.

1072

What is a virtual table in sql?

986