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
What is a db view?
Does sql server 2000 full-text search support clustering?
How can you manage sql azure security?
Can you explain important index characteristics?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Write a query to find 5th highest amount paid from the customer table.
What are the purposes of floor and sign functions?
What is the standby server?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
whats the maximum size of view state??
explain different types of joins? : Sql server database administration
How to name query output columns in ms sql server?
What is the largest component inside a field?
What samples and sample databases are provided by microsoft?
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?