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

How to connect of datebase with sql express.?

1062

How can I create a report based on a query? : sql server management studio

985

What are the advantages of user-defined functions over stored procedures in sql server?

983

How to turn off warning messages during php execution?

996

How to create nested stored procedure?

973

Explain about protocol layer present in SQL server?

1128

Explain the different index configurations a table can have?

903

Explain different types of Normalization.

1756

Can we do dml on views?

921

What are the different types of lock modes in sql server 2000?

893

List the types of recovery model available in sql server?

884

How you can get a list of all the table constraints in a database? : Sql server administration

962

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

933

Explain multiserver query

977

What specific conditions database should meet, before you can bulk copy data into it using bcp?

953