What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / satish kr verma
Some of the differeneces are mentioned below
Function -
1) Have to return a single value to the calling program
2) Can call functions in sql statements
3) Cannot return images
Procedures -
1) Do not return any value except assigning values to OUT
variables
2) Cannot call procedures in sql statements
3) Can return images
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is the default port for SQL Server over a firewall?
How to scale out a federation by Sql statement?
Difference between connected and disconnected database in .net with sql server?
What is clustered vs nonclustered index?
What is sqlcmd?
In which format does an image save in SQL Server database ?
What is the beast way to write CTE in SQL Server ?
What is serializable?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
How to use values from other tables in update statements in ms sql server?
How do I edit a procedure in sql server?
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? : Sql server administration
Ways to improve the performance of a SQL Azure Database?
What is the contrast between sql and mysql?