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

Answer Posted / dilip

HI FOR more specification for difference between sp and UDF
visit
http://sqldebate.blogspot.in/2012/02/diffrence-between-stored-procedure-and.html

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is coalesce and check constraint in sql server?

550


How extra digits are handled with numeric data type literals?

526


Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

559


How to drop an existing stored procedure in ms sql server?

548


What is the use of for clause?

585






Difference between drill down and drill through report.

547


Benefits of Stored Procedures?

573


How to count duplicated values in a column in ms sql server?

521


What happens if strings are casted into wrong code pages in ms sql server?

569


How to search for a string in all stored procedure in sql server?

540


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3761


Write a SQL query to delete a table?

657


What is reference section?

502


Explain transaction server consistency?

529


do you know how to configure db2 side of the application? : Sql server database administration

598