In this article, we will learn how to import excel file in the SQL table.
In this article, we will learn how to Concat columns in SQL.
In this article, we will learn how to use the Server Profiler in SQL Server.
Microsoft SQL Server Profiler is a graphical user interface for tracing, recreating, and troubleshooting problems in MS SQL Server, Microsoft’s relational database management system.
In this article, we will learn how to use the Date Formats in SQL.
SQL Server has many built-in Date Formats.
In this article, we will learn how to use the Date Functions in SQL.
SQL Server has many built-in Date Functions.
In this article, we will learn how to use the NULL Functions in SQL.
The following are the commonly used SQL NULL Functions.
In this article, we will learn how to use the Aggregate Functions in SQL.
An Aggregate Function allows us to perform a calculation on a set of values to return a single scalar value. We often use aggregate functions with the GROUP BY and HAVING clauses of the SELECT statement.
In this article, we will learn how to get the second highest salary in SQL.
In this article, we will learn how to use the String Functions in SQL.
SQL Server has many built-in String Functions.
In this article, we will learn how to create a View using SQL query.
The CREATE VIEW statement is used to create a new view in a database.
