difference between function and procedure
Answer Posted / ramya
1.a function must returns a value where as procedure may not return value
2.a procedure can have parameters of both i/p and o/p but
fun has only i/p parameters
3.in procedure we can perform all the dml operations but in function only select operation should be performed
4.we call a procedure by using 'exec' or 'execute' command where as function is called by using 'select' command
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the optimization being performed in oracle and SQL Server?
How to create an index on a view?
what are the new features in SSRS?
What is log shipping?
What is the size of transaction log file?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Why should one not prefix user stored procedures with ‘sp_’?
What is trigger in salesforce?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is a raid and what are different types of raid configurations?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Explain four layers of abstraction microsoft architectured?
What are the types of table?
What are system databases into sql server (2005/2008)?
Does transparent data encryption provide encryption when transmitting data across the network?