Answer Posted / srinivas k
Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to compare the top two records using sql?
What does it mean to normalize a database and why would you do it?
what is raid? : Sql server database administration
what is a self join? Explain it with an example? : Sql server database administration
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Do you know what are different types of replication in sql server?
Can you import Microsoft Excel data to SSRS?
What is the largest component inside a field?
What are the different types of backups avaialabe in sql server 2005?
Explain about integration services of Microsoft SQL server?
Please illustrate physical database architecture? : SQL Server Architecture
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
How to add an address record into adventureworkslt?
What do you mean by table and field in sql?
Define Joins?
