Intersect operator The intersect operator retrieves the common records between the left and right queries of the intersect operator. 1) This...
Cursors In SQL Server In a relational database management system takes into consideration then it would process the data in sets inefficient...
What is an Html Helper? Html helper is a method that is used to render HTML content in a view. Html helpers are implemented using an extension...
Suppose we want our URL in lowercase for that we need to code in ConfigureServices method where we can add a lowercase property in lowercase....
CTE Introduced in the SQL server 2005. CTE is like a temporary result set which is defined within the execution of the current context or...
In this article we will under stand How to Pass Data From Controller to View. How to Pass Data From Controller to View using ViewBag and...
Static properties and methods are those that don’t change with one instance to another instance. Also, if we declared static function then these...
Garbage collector only cleans managed code and if any unmanaged code it finds it doesn’t reclaim its memory so to remove unused objects we need...
Index is used to find data from the table quickly. An index is created on views and tables. It is similar to the book index. If you apply index it...
Private members in javaScript: In an object-oriented language like C#, Java they are having private and public members like variables and...
User-defined functions also called UDF. In SQL server there are 3 different types of User-Defined functions a) Scalar function. b) Inline...
An array is a collection and it is zero-indexed. The meaning of this is the first element is at index zero and the last element is at an index of...
Union and Union all are used to combine the result from two tables. It means when you want data from 2 different tables or 2 different queries and...
In the below program we create the variable x and assign value 10 after this we again assign value 12 to the same variable x and we print this on...
The SQL SELECT Statement The select clause can retrieve 0 or more rows from one or more tables from the database or it can retrieve rows from...
Google provides 2 different types of databases. a) Relational b) NoSQL/ NonRelational A) Relational: In this google have 2...
Open Redirection An Open Redirection is when a web application or server uses a user-submitted link to redirect the user to a given website or...
The auto property came into existence at C# version 3.0. It is used for code simplification and by using this your code becomes more readable...
Database: It is an organized collection of structured information or data, typically stored electronically in a computer system. It is usually...
If you are using C# as a primary programming language then your project file extension is .csproj and if you are using VB as the primary language...
Separate names with a comma.