SQL Server

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?

Similar Topics

Databases

2.3k+ articles

SQL

1.4k+ articles

Interview-Questions

450+ articles

SQL-Server

300+ articles

Interview Questions

220+ articles

MySQL

220+ articles

SQL-Query

170+ articles

SQL Server Query

40+ articles

Database Migration

12+ articles

SQLServer

9+ articles

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 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 Group by Day, Date, Hour, Month or Year in SQL Server

Last Updated: 02 February 2024

Grouping data by day, date, hour, month, or year in SQL Server involves using the GROUP BY clause and appropriate date functions to extract ...read more

How to Check a Column is Empty or Null in SQL Server

Last Updated: 31 January 2024

In SQL Server table columns, there can be times when there is NULL data or Column Value is Empty (''). When data is displayed or used in dat...read more

Recursive CTE in SQL Server

Last Updated: 16 January 2024

CTE which is the abbreviation for Common Table Expression is an SQL Server tool that returns a temporary data set that can be used by anothe...read more

SQL Server Row_Number Function With PARTITION BY

Last Updated: 28 December 2023

The row number function is one of the window functions used for assigning the row number to the rows in each of the partitions in the order ...read more

SQL Server DECIMAL Data Type

Last Updated: 12 December 2023

In SQL Server, when you need numbers to be super precise, like in financial calculations, you use the DECIMAL data type. It's like a special...read more

UNPIVOT in SQL Server

Last Updated: 01 December 2023

In SQL Server, Unpivot is a relational operator that allows us to convert columns into rows in a table. It's far the reverse of the Pivot op...read more

Rank and Dense Rank in SQL Server

Last Updated: 01 December 2023

The RANK() and DENSE_RANK() functions are essential tools in SQL Server for assigning rankings to rows in a dataset based on specified crite...read more

SQL Server - OVER Clause

Last Updated: 01 December 2023

The OVER clause is used for defining the window frames of the table by using the sub-clause PARTITION, the PARTITION sub-clauses define in w...read more

Rollup in SQL Server

Last Updated: 01 December 2023

The ROLLUP operator enhances the capabilities of the GROUP BY clause by enabling the computation of subtotals and grand totals for a set of ...read more