SQL Server Management Studio is a client tool that can be used to write and execute SQL queries in the Database SQL editor. To connect to SQL Server Management Studio We need to do the following things. Click on the start button in your computer Click on All Programs Choose Microsoft SQL Server 2008 or … Read moreHow to connect to SQL Server Management Studio?
In this article, we will discuss how to delete duplicate rows from a table in SQL server This is a very common SQL interview question. Here is the table with duplicate data, notice that mark record is duplicated 3 times Marry record 2 times and Ben record 3 times. Now the delete query that we … Read moreHow to delete duplicate rows from a table in SQL server?
In this article, we will discuss what is a trigger and different types of triggers in SQL. It is one of the most important topics also it comes under frequently asked interview questions. Beginners often think it is a very complicated topic and difficult to learn. Here I will teach you everything step by step … Read moreWhat are the types of Triggers in SQL? | A Complete Guide | Updated 2020
This article will describe the different types of SQL commands and their use. I will show you a step by step overview of different types of SQL commands that we commonly use. So that you will have a very clear understanding of this topic after reading this article. In general SQL commands are the predefined … Read moreWhat are the different types of SQL commands?
In this article, we are going to discuss SQL Having Clause in SQL Queries for various scenarios. By reading this article you will be able to know everything about SQL Having Clause. The SQL Having clause is used to specify a condition on aggregate functions and it is used along with the group by clause … Read moreWhat is SQL Having Clause? | The Complete Guide
This is a brief introduction to the SQL server management studio. For beginners, I will just cover the basic UI components and a few simple tasks that you can do. Here I have connected to SQL Server Management Studio. The first thing that asks me to do is connect me to a server. Management studio … Read moreWhat is SQL Server Management Studio?
In this article, we will discuss which are Pseudo Columns and its use. Pseudo columns are commonly asked SQL queries in interviews One must answer when any questions on this area because these are very basic and Pseudo columns are commonly asked SQL queries as well. Here I have displayed the column in the department … Read moreWhich are Pseudo Columns? | Complete Guide Updated 2020
In this article, you will be able to know how to create a table in SQL with simple steps. It is a very basic SQL concept and also it is a frequently asked interview question as well. By reading this article you will become a master in SQL table creation. I have created a sample … Read moreHow to Create a Table in SQL? Updated 2020
This article will help you to understand everything about SQL joins. These joins are very important and commonly asked in every SQL interview. SQL joins are basically 4 types. These joins are used to combine results from two are more tables. Inner Join Left Outer Join Right Outer Join Full Outer Join Inner Join Inner … Read moreSQL joins with examples | Everything about SQL Joins
This article will describe the comprehensive guide on Row Number and by reading this article you will be able to know everything about Row Number in SQL. What is the row number? what are all the prerequisites we need, to work with a Row Number? Row Number is a function that will help us to … Read moreWhat is Row Number in SQL?