Microsoft SQL Server Tutorials
As a database developer, you must know how to retrieve the information from the database based on the logical condition; here, I will explain SQL Server IIF logical function. This function allows us to evaluate the condition as true and false and, based on that, returns the specified value. I will start by explaining what … Read more
In this SQL Server tutorial, you will learn how to ALTER TABLE in SQL Server. You will understand the ALTER TABLE statement and why you should use it. Then, you will learn how to add a new column to an existing table, modify the column’s datatype, and drop the existing column of the table. Additionally, … Read more
Handling null values is a very important skill. As a database developer, you should know how to deal with null values in your table. This tutorial will explain how to use the SQL Server COALESCE function. A COALESCE() function is the one way to deal with null values; here, you will understand what the COALESCE() … Read more
In this SQL Server tutorial, I will explain how to apply conditions logic in your query using the CASE statement in SQL Server. As a database developer, you must understand how to use CASE statements to simplify the condition logic in your query. Also, how to categorize the data as requirements arise more simply. First, … Read more
In this SQL Server tutorial, I will show you how to use the CHOOSE function in SQL Server; this function helps in complex decision-making logic and simplifies the data retrieval process. As a database developer, you must know how to use this logical function, which resembles the workings of a CASE statement. But it is … Read more
Knowing how to manipulate data values is necessary as a database developer, so here I will explain the SQL Server EOMONTH function. This function can find the last day of any given date; as you know, in businesses, monthly reviews and reports are conducted, like financial statements and inventory audits; here, you can use the … Read more
In this SQL Server tutorial, I will show you how to use the SQL Server TOP clause to get only a limited number of data in the query’s result set. Where I will define ‘What is SQL Server Top Clause “, and with an example, I will explain how it works. Also, you will learn … Read more
If you want to know how to create clustered in SQL Server, this tutorial is for you. As the index improves the query performance, the clustered index plays a very important role in saving disk space and improving the speed of operation on the table. This tutorial is about clustered index, where I will explain … Read more
If you want to know how to speed up the operation on a table, then you must know how to create index in an SQL server and use it. Multiple operations are performed with a large database to retrieve the information from the database. As a developer, you should know how to improve the operation … Read more
In this SQL Server, you will learn about Pivot in SQL Server, a very useful way to transform rows into columns. You will be introduced to ‘What is Pivot in SQL Server?” which explains the meaning of Pivot. Then, the syntax of how to pivot the table or convert the values of a column into … Read more