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

How to copy data from one table to another table?

997

What happens if an integer is too big for int date type?

978

Explain different types of locks in sql server.

1082

How to find Duplicate Records In table?

1019

Is sql server free?

921

What is 2nf example?

1000

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

1015

What is the significance of null value and why should we avoid permitting null values?

989

Why are you getting errors when creating a new odbc dsn?

1225

where can you add custom error messages to sql server? : Sql server administration

1124

What is a join in sql? What are the types of joins?

1108

How do I know if localdb is running?

956

Introduction of rollup clause using sum and group by clause?

968

What is the use of partition by in sql server?

933

What is sql injection and why is it a problem? : sql server security

1136