Switch Case,switch Statement in C#.NET

switch case or Switch statement Switch statement is used to move the program control to a specific "Switch Case" based upon the Switch expression. It can be used as a alternative to IF-ELSE. Below is the skeleton for the Switch case . switch (expression)   {    ...

Share:

Read More

Understand Conditional Statement in C#

Introduction Conditional statement is a set of Rule performed if a certain Condition met. We can achieve this using IF-ELSE Statement. Skeleton of IF-ELSE Statement if(<condition-1>) {       print message } else if(<condition-2>) {    ...

Share:

Read More

Introduction To C# with an Example

Introduction to c# C#  is a high level language and its first version C# 1.0  released by Microsoft in 13th February 2002. Syntax is almost similar to C++. what is c#? C# is an Object Oriented Programming Language Developed By Microsoft. C# is a high level...

Share:

Read More

difference between where and having clause in sql server

Introduction Both Where and and having clause used to filter the record but for different purpose. Lets Get Started Where clause used to filter the data by row where as Having clause  is used to filter based upon the aggregate data. Lets...

Share:

Read More

Difference between Union and Union All

Introduction Both Union and Union All are Used to Join Rows of two or more tables. But the Union Or Union All  need the datatype same . Lets Understand with the below example. Difference-1 Union  Union will combine table rows and will display the non...

Share:

Read More

Dynamic SQL Query in SQL Server and Why We Need This

Introduction Before Dive into the Topic of Dynamic SQL query lets have a look into Static query and why we need dynamic SQL query even though we have Static query .Lets Get Started....See the below Image which describes the SQL Queries types based upon the execution.Basically...

Share:

Read More

Understand Table Variable and Temp Table In SQL Server

(adsbygoogle = window.adsbygoogle || []).push({}); Introduction  As we know both Temp table and Table Variable are used to store the data temporarily. But both have their pros and cons.We should have good understanding when to use what to improve our coding standard. Lets...

Share:

Read More

Normalization In Sql Server

Introduction Normalization is Nothing but efficiently organizing the data in SQL Server.  Its very easy to understand when data in a table is simple and well-organised That is what Normalization do. Structuring of data can be of 2 types. Normalization De-Normalization See...

Share:

Read More