Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 112816 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
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
What is bit data type? What's the information that can be stored inside a bit column?
What are orphan records?
What is a recursive stored procedure in sql server?
Write a query for primary key constraint with identity key word?
How the authentication mode can be changed?
What is sqlservr.exe - process - sql server (sqlex?press)?
What is the Control Flow in SSIS
What is an inner join?
Is resultset an interface?
What is the difference between dbcc indexdefrag and dbcc reindex?
Mention the differences between having and where clause.
Can you insert NULL in unique column?
What are the new features of sql server 2012 reporting service?
what is a self join? : Sql server database administration
Explain what is scheduled job and how to create it?
