Angular, JavaScript, JQuery, C#, ASP.NET, MVC

In this blog we are going to understand some important queries... Created new database and tables for solving following queries : Union : Union removes duplicate records from data sets. Union first performs sorting operation and then eliminate duplicate records in data sets, after that they return combined data sets. Example : Union All : Union All keeps all records from each data sets. It also contains duplicate records. Example : Group By : Group by is used to group the rows that have same values or it is used to organize similar data into groups. Attribute i.e used in aggregate function cannot be in group by statement. The attribute used after group by statement and attribute used in aggregate function are only allowed if rather than this another attribute used, it shows error : Example : Order By : Order by is used to sort the data in ascending or descending order. Example : Subquery : Subquery is the query within another query and included within WHERE clause. The outer query is k...

As we saw in previous blog, we are continuing the same i.e understanding concepts of SQL.  Q. How can we create a composite key? The combination of two or more columns that are used for unique identification of row in table. Sometimes more than one attribute is needed to identify an entity. In simple words we can say that, primary key created on multiple columns.  Q. What is data integrity? The consistency and accuracy of data is called as data integrity. Data integrity is classified into two types : System defined integrity : (using constraints) User defined integrity : (using triggers) Again the system integrity is divided into three types: 1) Entity Integrity :                   Entity integrity is used for uniquely identifying entity of each row in table. We can apply this to table by specifying primary key, unique key and not null. 2) Referential Integrity :                  ...

              In this blog we are going to understand the important and basic concepts of SQL... Q. How to  create a SQL server database  connection and new database? 1. Firstly open SSMS and connect with server also ensure SQL Server(MSSQLSERVER) is in running mode - 2. Create a new database -                                                              3. Create a table - // U need to refresh whenever u add a new table            Q. What is primary key and foreign key in SQL server? Primary Key :  Primary key is a column having unique record. Primary key cannot have NULL values. It is used to uniquely identify records in relational database. Only one primary key is allowed in a table. When we delete or update records, data integrity happens. Foreign Key...

 In this blog, we are going to understand the installation steps of SQL server and SSMS. SQL Server : SQL server is a relational database management system developed by Microsoft. You can download SQL server 2019 version from here  download Their are some editions in SQL : Developer : This edition used in development, non-production and test systems. Microsoft made this edition free. Express : This edition used in development and production on desktop. Also for web and small applications. This is free for some period of time. Installation steps : 1. Run the installed application from download. 2. Select custom option and allow application to download and install all packages. Also specify path where you are going to download application. 3. After this you see new page as SQL server installation center choose installation from menu. 4. Now choose the "New SQL server stand-alone installation". 5. Choose the edition "Developer" then accept the license terms. 6. Click o...

  Q. Why http protocol is called as stateless ? HTTP protocol is called as stateless because the http server not keeps the record of any information. When client requests to server, every time request treated independently(it not checks whether it requested before or not) by server. We can also say that when client ends the process of any task the connection between server and browser also terminated. In below example we can see that after accessing browser when we again access the value of i starts again from 0.                                                   Stateless Protocol : Stateless protocols are the protocols in which client sends request to server and server response back to client based on current state.  Server not require to maintain information of each client with multiple requests. Some important features of stateless protocol are :...