Reset identity column in SQL Server.

Hi All,

Hope you all are doing good.

In this article, we will know about how to reset identity of table in SQL Server.

Various ways of deleting duplicate records from table in SQL Server

Hi All,

Hope you all are doing good.

In this article, we will know about various ways of removing duplicate records from table in SQL Server.

Type conversion functions in SQL Server

Hi All,

Hope you all are doing good.

In this article, we will know about type conversion functions in SQL Server.

Various ways of replacing NULL

Hi All,

Hope you all are doing good.

In this article, we will know about various ways of replacing NULL value.

Similarities and differences between UNION and UNION ALL in SQL server

Hi All,

Hope you all are doing good.

In this article, we will know about similarities and differences between UNION and UNION ALL.

Difference between SCOPE_IDENTITY(), @@IDENTITY and IDENT_CURRENT()

Hi All,

Hope you all are doing good.

In this article, we will know about when to use below ones.

Similarity and difference between Primary Key and UNIQUE constraint

Hi All,

Hope you all are doing good.

In this article, we will know what is similarity and difference between Primary Key and UNIQUE constraint.

Various ways to insert data into table in SQL server

Hi All,

Hope you all are doing good.

In this article, we will know about various ways of how to insert data into tables.

Difference Between TRUNCATE, DELETE and DROP In SQL Server

Hi All,

Hope you all are doing good.

In this article, we will know about what are the various differences between TRUNCATE, DELETE and DROP statements in SQL server.

How to implement two interface with same method in C#?

Hi All,

Hope you all are doing good.

In this article, I will explain you about how to implement two interfaces with same method in C#.