What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106098 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / vijayabhaskarreddy
there are 3 main differences between sp and function.
1 sp takes input,output parameters, function takes only
input parameters.
2 temparary variables required to store return values of
sp. in functions temparary variables will be optinale.
3 sp can not be called directly into DML statements ,
functions can be called directly into DML statements.
| Is This Answer Correct ? | 64 Yes | 19 No |
Post New Answer View All Answers
How to perform backup for certificates in sql server? : sql server security
How to delete a login name in ms sql server?
What is the difference between char, varchar and nvarchar?
Is it important for a database administrator to understand the operating system and file access?
What is row-level compre?
How to set a database state to offline in ms sql server?
How do I view views in sql server?
How do you run a trace?
What is format parameter in ssrs?
Do you know what are pages and extents? : SQL Server Architecture
What are the different sql server versions?
What is temporal table?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Define right outer join?
List few advantages of stored procedure.
