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
- 112000 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 transact-sql language?
What is the use of sql profiler in sql server 2012?
What is row_number function?
How to list all objects in a given schema?
How to create stored procedures with parameters in ms sql server?
List the various tools available for performance tuning?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
explain different types of constraints? : Sql server database administration
What are the dmvs?
What is a trigger what are the advantages of trigger?
What is the difference between implicit and explicit transaction?
What is temporary stored procedure?
what are the disadvantages of cursors? : Sql server database administration
Explain the rules for designing files and file groups in sql server?
Explain left outer join and right outer join?
