Difference between Function and Stored Procedure?
Answer Posted / arvind kumar
1-Function can not return the value but store procedure
return value
2-Store procedure is pree-compile statement but function is
not pree-compile satement.
3 function fallowed by select statement but store procedure
fallowed select, insert,update statement.
| Is This Answer Correct ? | 2 Yes | 40 No |
Post New Answer View All Answers
What are the system database in sql server 2005?
Write a program to fetch first 10 records from a file?
Why should we go for stored procedures? Why not direct queries?
What are sparse columns?
How many clustered indexes there can be on table ?
What is temporal data type?
What is sql server profiler?
How do I setup a local sql server database?
What is the difference between online clustering and Offline clustering?
what are isolation levels? : Sql server database administration
Mention the different authentication modes in sql server.
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Mention what are the core components of ssrs?
How to perform key word search in tables?
Explain about merge replications?