Difference Between Functions and Stored Procedures in SQL
User Defined Functions Stored Procedure Functions must return a value Stored Procedure may or may not return values It will allow only SELECT statements, DML... Read more
Month: February 2017
Calling a Function from Stored Procedure
In this article we will see how can we call a Function inside a Stored Procedure. You can read about Functions and Stored Procedures. First... Read more
How to create Stored Procedure with Default Values?
Hello Readers today we will going to learn how to Create STORED PROCEDURE with Default Parameters. I hope you all have gone through my previous... Read more
Stored Procedures in SQL
Stored Procedures are a set of SQL Commands / statements which are stored in a compiled form. Syntax: CREATE/ALTER Procedure <Procedure-name> ( Input parameters ,... Read more
Functions in SQL
What are Functions in SQL SERVER? Functions are the objects which performs an action based on input values (input parameters) and can return only single... Read more
Garbage Collection in C#
Garbage Collector is an automatic memory manager. It frees the memory occupied by objects which are no longer in use by the application. It works... Read more
Reflection in C#
Reflection is a namespace which provides objects that encapsulate assemblies, modules and types. The objects are of type ‘Type’ (System.Type). With the help of these objects,... Read more
Difference between Interface and Abstract class in C#
This is the commonly asked question by the interviewers that what is the difference between Interface and Abstract class. You can also read these articals... Read more
Sealed Classes in C#
Sealed Classes are the classes that cannot be inherited. It restrict Inheritance, you cannot use it as a base class. It is define with the... Read more
Interface in C#
Interface is a set of similar functionalities that can be implemented by a class or struct. You can think it as a contract in which... Read more