JavaScript

Concept Of SQL Server Union : Union is used to combine data of one or more tables. Union only distinct values are allowed. The following SQL statement returns the Id, FirstName, LastName (only distinct values) from both the " tblCustomer " and the " tblCustomerExpired " table : Two Table : tblCustomer tblCustomerExpired Example : Union all : Union all is used to combine data of one or more tables. Union all duplicates values are allowed. The following SQL statement returns the Id, FirstName, LastName (duplicate values also)from both the "tblCustomer" and the "tblCustomerExpired" table : Two Table : tblCustomer tblCustomerExpired Example : Group By Clause : Group by clause is used to combines the groups rows that have the same values into rows. The Group By clause is used with aggregate functions (COUNT(), MAX...

Understanding Questions For SQL Server & SQL Server Management Studio What is a Primary Key in SQL Server ? Primary Key : A primary key is a field in a table which uniquely identifies each row/record in a database table.  Primary keys must contain unique values. Explain What is a Identity Column ? Identity column of a table is a column whose value increases automatically.  The value in an identity column is created by the server.  A user generally cannot insert a value into an identity column. Identity column can be used to uniquely identify the rows in the table. How can I create One to Many relationship ? In a one-to-many relationship, one record in a table can be associated with one or more records in another table. How can I create Primary Key & Foreign Key relationship ? In a foreign key reference, a link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the col...

Learn SQL Server Management Studio (SSMS) What is SQL Server Management Studio  ( SSMS ) ? SQL Server Management Studio : SQL Server Management Studio (SSMS) is a software application first launched with  Microsoft SQL Server 2005   that is used for configuring, managing, and administering all components within Microsoft SQL Server. Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure. How to Download and Install SQL Server Management Studio ( SSMS ) : We can use the following steps to download and install Microsoft SQL Server Management Studio ( SSMS ) in the Windows system : Step 1 : Go to the clicking on this link and click on Download SQL Server Management Studio 18.08. Step 2 : Once the file has been downloaded, it will be named "SSMS-Setup-ENU.exe." Now, double-click on it to continue. Step 3 : Here, we can change the installation location and then click t...

Introduction To SQL Server What is SQL Server  ? SQL Server : SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft.  As a database server, the primary function of the SQL Server is to store and retrieve data used by other applications. Microsoft provides two specialized free editions to work on MS SQL server : 1) Developer : It has all feature which MS SQL server offers but we cannot use it in productions. Developer is the same as Enterprise, but for non-production use. It is used to learn, build and test. 2) E xpress : This is also a free version but with the limited set of features with no business intelligence applications. It has 10 GB size limit, only used for small applications. Install SQL Server 2019 Developer Edition on Windows Server 2019 : Microsoft produces SQL Server Developer edition is a full-featured free edition, licensed for use as a development and test database in a non-production envir...