Function return only one value where as procedure can more than

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

Question Posted / pss

Answer Posted / pss

Function return only one value where as procedure can more
than

Is This Answer Correct ?

58 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is the largest component inside a field?

1026

What is cdc in sql server?

950

What is raid, and how it can influence database performance?

1005

Is it possible to replicate data from sql server to oracle? : sql server replication

1033

How does the report manager work in SSRS?

142

How to recreate an existing index in ms sql server?

984

How can you append an identity column to a temporary table?

873

Is sql server 2016 free?

881

can an automatic recovery be initiated by a user? : Sql server administration

893

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1030

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

861

How to retrieve error messages using mssql_get_last_message()?

990

Detail about query optimizer?

1033

Explain can SSRS reports Cache results?

149

What do you mean by collation recursive stored procedure?

1009