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

How column data types are determined in a view?

534


how to control the amount of free space in your index pages? : Sql server database administration

598


Can we add our custom code in ssis?

543


What is the name of the Database which IBM mainframe uses?

536


How to deploy the Report?

93






Do you know how to store and query spatial data?

602


Can we update data in a view?

599


Can we create clustered index on composite key?

513


What is difference between index seek vs. Index scan?

620


Ways to improve the performance of a SQL Azure Database?

103


What are the three different part of rdl file explain them?

170


What is the importance of three tier architecture?

607


What is the server name for sql management studio?

473


Explain a differential backup?

573


what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

509