Difference between Stored Procedure and Function in SQL Server Stored Procedures are pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled code) whenever it is called. But Function is compiled and executed every time when it is called. For more about stored procedure and function refer the articles Different types of Stored Procedure and Different types of Function. Basic Difference 1.       Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values). 2.       Functions can have only input parameters for it whereas Procedures can have input/output parameters . 3.       Function takes one input parameter it is mandatory but Stored Procedure may take o to n input parameters.. 4.       Functions can be called from Procedure whereas Procedures cannot be called from Function. Adv...

This article will help your in understanding .NET and .NET architecture. What is the .NET Framework? The .NET Framework is a new and revolutionary platform created by Microsoft for developing applications.   ·          It is a platform for application developers. ·          It is a Framework that supports Multiple Language and Cross language integration. ·          IT has IDE (Integrated Development Environment). ·          Framework is a set of utilities or can say building blocks of your application system. ·          .NET Framework provides GUI in a GUI manner. ·          .NET is a platform independent but with help of Mono Compilation System (MCS). MCS is a middle level interface. ·      ...