SQL Server

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

Similar Topics

Web Technologies

37.8k+ articles

DSA

21.9k+ articles

Geeks Premier League 2023

7.1k+ articles

Databases

940+ articles

SQL-Server

300+ articles

SQL-Query

170+ articles

interview-questions

88+ articles

Interview Questions

53+ articles

SQL Server Query

40+ articles

SQLServer

9+ articles

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 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 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

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

Dynamic Table Name Variable in SQL Server

Last Updated: 28 December 2023

In SQL Server, the dynamic table name variable is used when the name of the table is not explicitly stated in a query but is set in a variab ...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

Difference Between DateTime and SmallDateTime in SQL Server

Last Updated: 01 December 2023

SQL Server datatypes are used to store date and date and time values in the database, there are various types of date data types available i...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