Stored procedure have the security and reduce the network traffic. and al

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

Question Posted / ugandhar

Answer Posted / ugandhar

Stored procedure have the security and reduce the network
traffic.
and also we can call stored procedure in any no.of
applications at a time.

Is This Answer Correct ?

46 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What is bit data type? What's the information that can be stored inside a bit column?

923

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2787

What do you mean by sql server 2005 express management tools?

1313

What is GUID in sql server?

1167

Do comments need to go in a special place in sql server 2005?

861

Difference between connected and disconnected database in .net with sql server?

1103

When do you think a developer should use sql server-based cursors?

1052

How do you create a clustered index?

1058

Define clusters?

1085

What is the beast way to write CTE in SQL Server ?

1047

How can we determine what objects a user-defined function depends upon?

1017

What is data source view or dsv? : sql server analysis services, ssas

1006

Explain trigger classes i.e. Instead of and after trigger?

883

What is serializable?

1046

What do you understand by replication in sql server?

1066