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

Answer Posted / srinivas

Stored procedures are a set of actions already written and
stored inside the database for acheiving a particular task
where as functions are general database objects which are
used for general purpose programming

Is This Answer Correct ?    46 Yes 27 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List the data types available in mssql?

540


How to divide query output into multiple groups with the group by clause in ms sql server?

578


What is bit data type?

633


What is intellisense?

604


How to modify existing triggers using "alter trigger"?

536






What the difference between UNION and UNIONALL?

576


Explain about sql server login?

608


How to find out what is the default collation in a database?

636


 Explain what is sql override for a source taLle in a mapping?

581


How to download microsoft sql server 2005 express edition?

587


How does normalization work?

512


Can we call stored procedure in trigger?

557


How to disable triggers using "disable trigger"?

574


What is the distinction amongst delete and truncate?

593


Explain indexed views and partitioned view with their syntax.

694