What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106257 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
What is auditing in sql server?
Write the syntax for stuff function in an sql server?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Explain the use of containers in ssis and also their types?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is difference between count (*) and count 1?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Define msdb database?
How to create a simple stored procedure in ms sql server?
Explain contrast amongst grouped and non-bunched records?
Explain logical operators in sql server?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is difference between primary key and foreign key?
What is transactional replication?
