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

Do you know what guidelines should be followed to help minimize deadlocks?

920

Which is better statement or preparedstatement?

868

How to create a new login name in ms sql server?

994

How do you create type- insensitive operator?

994

Where the sql logs gets stored? : sql server database administration

915

Why normalization is used?

965

What is difference between commit and rollback when used in transactions?

904

How does recursive cte works in sql server?

941

How to call a function from a stored procedure in SQL Server ?

952

Explain following error properties?

955

What is the log shipping?

952

What do you understand by a view? What does the with check option clause for a view do?

952

Which sql server table is used to hold the stored procedure script?

881

What is create command?

927

What is ms sql server triggers?

942