Category: Server Tutorials

In SQL Server, the INTERSECT operator is used to fetch the records that are in common between two SELECT statements or data sets. If a record exists in one query and not in the other, it will be omitted from the INTERSECT results. Syntax: Parameter explanation expression1, expression2, … expression_n: expressions specify the columns or calculations…

A datatype ensures which type of data our column or variable can store in SQL Server. When we create any table or variable, it is required to specify the type of data it will store in addition to the name of each column. For example, in SQL Server, each table has many columns and contains…

MS SQL Server Management Studio is a workstation or a client tool which is used to connect to and manage your SQL Server SQL Server Management Studio (SSMS) is a windows software or a client tool used to connect and work with our SQL Server from a graphical interface instead of using the command line. Microsoft SQL Server 2005…

This article gives a complete overview of how we can install and configure SQL Server using the Installation Wizard. It explains the step-by-step procedure to use the SQL Server Setup Installation Wizard to install a new instance of SQL Server. With this setup, we don’t have to install each SQL Server component individually because the Installation…

Microsoft Visual Studio is an integrated development environment (IDE) which is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. It supports different programming languages like C,C++ and C++/CLI, Visual Basic .NET, C#, and F#. It is used when you want to make programs on ASP.NET…

SQL Server Tutorial provides basic and advanced concepts of SQL Server. Our SQL Server Tutorial is designed for beginners and professionals both. SQL Server is software (A Relational Database Management System) developed by Microsoft. It is also called MS SQL Server. It is implemented from the specification of RDBMS. Our SQL Server Tutorial includes all…