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 to drop an existing table?
Difference between DELETE and TRUNCATE?
What is difference between commit and rollback when used in transactions?
What is the difference between value type and reference type?
Tell me about builtinadministrator?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to backup SQL Server Reporting Services ?
What are the differences between char and varchar in ms sql server?
What is it’s similarity with sql server?
Explain triggers in sql?
What are the different normalization forms?
What is the size of transaction log file?
How do I find the sql server version?
Where is my database stored on the hard disk in ms sql server?