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.

Built-in Date functions in SQL Server

Hi All,

Hope you all are doing good.

In this article, we will know about various T-SQL Date functions and their uses.

Built-in string functions in SQL Server

Hi All,

Hope you all are doing good.

In this article, we will know about various T-SQL string functions and their uses.

Stored Procedures in T-SQL

Hi All,

Hope you all are doing good.

In this article, we will know about stored procedures in T-SQL.

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.

Constraints in SQL Server

Hi All,

Hope you all are doing good.

In this article, we will know about various key constraints available in T-SQL.

LIKE operator in SQL Server

Hi All,

Hope you all are doing good.

In this article, I will explain you about how to use LIKE operator in different scenarios.

Update statement in T-SQL

Hi All,

Hope you all are doing good.

In this article, we will know about how to update data in a table.

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.

Cascading referential integrity constraints

Hi All,

Hope you all are doing good.

In this article, we will know about various referential actions of Foreign Key.

How to create a Foreign Key in SQL Server

Hi All,

Hope you all are doing good.

In this article, we will know about how to create Foreign Key relation between two tables.

Query data using select command in multiple ways using T-SQL

Hi All,

Hope you all are doing good.

In this article, I will explain you about how to use select command in different scenarios.

How to rename a database and table in SQL Server

Hi All,

Hope you all are doing good.

In this article, I will explain you about how to rename a database and table in SQL server.

Basic T-SQL Commands

Hi All,

Hope you all are doing good.

In this article, I will explain you about T-SQL commands.

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