Difference between a Procudure and Function

A FUNCTION is always returns a value using the return statement. A functions can be useed in select or update or delete statement while procedure can't.

A PROCEDURE may return one or more values using the OUT parameteror may not return at all.

 


Elements of a ASP.NETpage | ASP.NET General Test Questions | ASP.net 2.0 DataControls | Client/Server Software Architecture | Configure Microsoft SQL Server for Mixed Mode Authentication | Connection Pooling | Cookies | Create Table and Insert table command | Database Life Cycle | Data Source Controls in ASP.net2 | Difference between DLL and exe? | Difference between Interface and Class? | Difference between Query and ad hoc query | Difference between Truncate and delete command | Using Microsoft Visio for ERD drawing | Event Bubbling | Functions and Delegates in ASP.NET | Global assembly Cache(GAC) | Input Validation Controls in ASP | Vb Interview Questions | What are Joins? | What is an N-tier application? | Outer Join and Inner Joins | Pascal Notation | What is a Process? | Resources | ASP.net 2 SqlDataSource Control | System Development Life Cycle | Table structure | Thread | Transaction Control Statements | Triggers and Stored procedure and difference between them | Notations used in Visual Basic | RadioButton in Visual Basic | Structure in Visual Basic | What is a 3 -tier architecture? | What is ASP.NET? | What is Boxing and Unboxing | What is Data Dictionary? | Function | Reflection | Difference between XHTML and HTML