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
- 113735 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / arvind kumar
there main difference:::
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 ? | 13 Yes | 2 No |
Post New Answer View All Answers
how you can get the list of largest tables in a database? : Sql server administration
Can a function call a stored procedure in sql server?
What is primary key and example?
How to start sql server browser service?
Describe how to use the linked server?
difference between Clustered index and non clustered index ?
What is merge replication?
What is the new security features added in sql server 2016? : sql server security
Find columns used in stored procedure?
How to find the source of a table in sql server?
Do you know what are the reporting services components?
What does it mean to normalize a database and why would you do it?
What is ddl and dml commands?
What is the cartesian product of the table?
What are page splits? : SQL Server Architecture
