The break statement is used to terminating the running statement of program and transfer controls to the next execution . In other words The C# break statement is used to break loop or switch statement . It breaks the current flow of the program at the specified condition.
The C# continue statements enables you to skip the loop and jump the loop to next iteration. It continues the current flow of the program and skips the remaining code at specified condition. In case of inner loop, it continues only inner loop.
The process of creating same name method with same signatures in base class and derived class is called as method Overriding. Overriding also called as run time polymorphism or dynamic polymorphism.
The process of creating more than one method with different signatures in a class with same name or creating a method in derived class with same name as a method with different signatures in base class is called as method overloading.
In C# Structure is the value type data type that can contain variables, methods, properties, events ,constants, constructors, indexers, operators and even other structure types. structure are created in stack. It simplifies the program and enhance performance of code in C# programming.
An abstract class is a particular kind of class that cannot be instantiated. it only allows other classes to inherit from it but cannot be instantiated. The purpose of an abstract class is to provide a common methods or properties of a base class that multiple derived classes can use
The Dense_Rank() Function function return a rank based on the partitioned column order when two rows have the same order value. It provides the same rank for the two rows and it will not leave gaps in the ranking.
The Rank function return a rank based on the partitioned column order when two rows have the same order value. It provides the same rank for the two rows and also increases the same order by clause.
A unique key in SQL Server is uniquely identify a record in a database table. It can have one or more than one fields/columns in a table. It’s like primary key but it can accept only one null value and it cannot have duplicate values. The unique key and primary key both provide a guarantee for uniqueness for a field/column or a set of fields/columns.
In SQL Server foreign key is a column (or columns) in one table that uniquely identifies a row of another table. In simpler words, the foreign key is defined in a second table, but it references to the primary key in the first table.