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
How column data types are determined in a view?
how to control the amount of free space in your index pages? : Sql server database administration
Can we add our custom code in ssis?
What is the name of the Database which IBM mainframe uses?
How to deploy the Report?
Do you know how to store and query spatial data?
Can we update data in a view?
Can we create clustered index on composite key?
What is difference between index seek vs. Index scan?
Ways to improve the performance of a SQL Azure Database?
What are the three different part of rdl file explain them?
What is the importance of three tier architecture?
What is the server name for sql management studio?
Explain a differential backup?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration