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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a db view?

525


Does sql server 2000 full-text search support clustering?

512


How can you manage sql azure security?

87


Can you explain important index characteristics?

535


what is the Ticketing tool used in Wipro technologies at Bangalore...???

7488






Write a query to find 5th highest amount paid from the customer table.

544


What are the purposes of floor and sign functions?

546


What is the standby server?

526


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

544


whats the maximum size of view state??

1728


explain different types of joins? : Sql server database administration

540


How to name query output columns in ms sql server?

542


What is the largest component inside a field?

538


What samples and sample databases are provided by microsoft?

581


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

577