SQL-Server

300+ posts

SQL Query to Convert Rows to Columns in SQL Server

Last Updated: 16 December 2021

In this article we will see, how to convert Rows to Column in SQL Server. In a table where many columns have the have same data for many ent ...read more

SQL

SQL-Server

Picked

SQL-Query

How to Update Multiple Records Using One Query in SQL Server?

Last Updated: 13 May 2024

To update multiple records in the SQL server, use the UPDATE Statement. Using the SQL UPDATE statement with the WHERE clause users can upda...read more

SQL

SQL-Server

Picked

How to Select Data Between Two Dates and Times in SQL Server?

Last Updated: 19 November 2021

In SQL, some transactions need to be extracted based on their completion times and dates. Here, the DATETIME2 data type in SQL to perform su...read more

SQL

SQL-Server

Picked

Similar Topics

Difference Between

3.6k+ articles

Databases

2.2k+ articles

How To

1.7k+ articles

DBMS

1.5k+ articles

SQL

1.5k+ articles

Installation Guide

1.2k+ articles

how-to-install

1.2k+ articles

DBMS-SQL

510+ articles

mysql

310+ articles

SQL-Query

170+ articles

SQL Query to Convert VARCHAR to INT

Last Updated: 08 January 2025

In SQL, converting data types is a common operation, and one of the most frequently required conversions is from VARCHAR to INT. This conver ...read more

How to Find Duplicate Records in SQL?

Last Updated: 30 December 2024

To find duplicate records in SQL, we can use the GROUP BY and HAVING clauses. The GROUP BY clause allows us to group values in a column, and...read more

How to Write a SQL Query For a Specific Date Range and Date Time?

Last Updated: 16 December 2024

Managing date and time in SQL is a critical task for many real-world applications, especially when handling time-sensitive data such as logs...read more

How to Update Multiple Columns in Single Update Statement in SQL?

Last Updated: 17 December 2024

The SQL UPDATE statement is a important operation for modifying existing records in a database table. It allows us to change the values of o...read more

SQL Query to Get Column Names From a Table

Last Updated: 10 October 2021

SQL stands for Structured Query Language. It is a language used to interact with the database, i.e to create a database, to create a table i...read more

SQL Statement to Remove Part of a String

Last Updated: 19 September 2024

Here we will see SQL statements to remove part of the string.Method 1: Using SUBSTRING() and LEN() functionWe will use this method if we wan ...read more

SQL Query to Compare Two Dates

Last Updated: 26 September 2021

In SQL, dates are complicated for newbies, since while working with the database, the format of the date in the table must be matched with t ...read more

SQL Query to Delete Duplicate Rows

Last Updated: 14 April 2025

Duplicate rows in a database can cause inaccurate results, waste storage space, and slow down queries. Cleaning duplicate records from our d...read more

SQL Query to Exclude Null Values

Last Updated: 23 December 2024

In relational databases, managing NULL values is a critical aspect of data integrity and accuracy. A NULL value signifies the absence of dat...read more

SQL - SELECT from Multiple Tables with MS SQL Server

Last Updated: 14 June 2021

In SQL we can retrieve data from multiple tables also by using SELECT with multiple tables which actually results in CROSS JOIN of all the t...read more

RANK() Function in SQL Server

Last Updated: 11 April 2025

The RANK() function is a powerful window function in SQL Server used to assign a rank to each row within a result set. It is particularly us ...read more

Last Updated: 15 May 2025

The LAG() function in SQL is one of the most powerful and flexible tools available for performing advanced data analysis. It is often used t ...read more

1 2 3 4 5 6 7 8 >>

1 2 3 4 5 6 >>

1 2 3 4 >>