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
Are semicolons required at the end of sql statements in sql server 2005?
What are the features of Embedded SQL
How to replace given values with null using nullif()?
What is the report builder?
Is ssrs support other database except ms sql server?
How to run queries with sql server management studio express?
How to find table changes in sql server?
Explain transaction server distributed transaction?
What are the advantages of paper records?
Can you import Microsoft Excel data to SSRS?
What is the difference between getdate and sysdatetime?
How to use “drop” keyword in sql server and give an example?
What is the difference between dataadapter and datareader?
Is it possible to update the views? If yes, how, if not, why?
What is the use of builtinadministrators group in sql server? : sql server security