SQL Server Query

How Stuff and 'For Xml Path' work in SQL Server?

Last Updated: 19 March 2024

While working on the SQL Server database, we frequently encounter situations where data manipulation, like concatenating values from multipl...read more

How to Select the nth Row in a SQL Server Database Table?

Last Updated: 12 March 2024

In SQL Server databases, it's common to encounter scenarios where we need to retrieve a specific row, such as the nth row, from a table effi...read more

Similar Topics

Web Technologies

41k+ articles

DSA

22.3k+ articles

Python

20.1k+ articles

Experiences

17k+ articles

Interview Experiences

13.6k+ articles

School Learning

12.9k+ articles

JavaScript

11.8k+ articles

Java

10.2k+ articles

Databases

2.3k+ articles

SQL Server

150+ articles

How to Use STRING_AGG to Concatenate Strings in SQL Server?

Last Updated: 12 March 2024

In SQL Server, string concatenation can be a powerful tool for aggregating data and creating concise, informative results. One of the most e...read more

How to Retrieving the Last Record in Each Group in SQL Server

Last Updated: 05 March 2024

In SQL Server data analysis, the need to retrieve the last record in each group is a common and essential task. Consider a scenario where y...read more

How to SELECT Top N Rows For Each Group in SQL Server

Last Updated: 20 February 2024

SQL Server’s ROW_Number() window function is often used to get the top number of rows in a group. In this article, we’ll look at how to ...read more

SQL Server SELECT INTO @Variable

Last Updated: 12 February 2024

In the world of SQL Server, the SELECT INTO statement is a powerful syntax for retrieving data from one or more tables and inserting it into...read more

How to Add an IDENTITY to an Existing Column in SQL Server

Last Updated: 02 February 2024

It enables you to store, organize, and manipulate data in a relational format, meaning data is organized into tables. It Stores and manages ...read more

How to Insert Line Break in SQL Server String?

Last Updated: 02 February 2024

In SQL Server there are various datatypes like int, float, char, nchar, etc but especially while we are dealing with text in VARCHAR and NVA...read more

How to Insert If Not Exists in SQL SERVER?

Last Updated: 02 February 2024

Adding Data to a table in SQL Server is a key operation. Data can be inserted into tables using many different scenarios like plain data ins...read more

How to Update If Row Exists Else Insert in SQL Server

Last Updated: 02 February 2024

Data update and data insert are two important functions to add and update data in SQL Server Tables. Using SQL queries we can check for spec...read more

How to Turn IDENTITY_INSERT On and Off Using SQL Server?

Last Updated: 02 February 2024

IDENTITY_INSERT in SQL Server is a valuable tool in SQL Server 2008, allowing us to control how identity values are assigned when inserting...read more

How to Search Text in a SQL Server Stored Procedure

Last Updated: 02 February 2024

A stored procedure is a compiled SQL code that is saved in the database and can be reusable by calling this from a Client Application or ano...read more

How to Remove Times from Dates in SQL Server

Last Updated: 02 February 2024

In SQL Server, there are Date and DateTime data types to store Date and Time values. There can be situations when only the date value needs ...read more

How to Concatenate Text From Multiple Rows in SQL Server

Last Updated: 02 February 2024

When we fetch data from a table, there may be requirements to concatenate the text value of a table column in multiple rows into a single ro...read more