In this blog, I will discuss the collate clause and also discuss how the expression type 'int' is invalid for collate clause error in the SQL server.

In this blog, I will explain the SQL Transaction.

There are many issues when we work with SQL server. This blog will introduce a tool which we can use to repair corrupted SQL Server DBS

This blog post is for advanced T-SQL developers interested in implementing custom sequences. Customizing the sequence gives more flexibility while implementing a solution.

In this blog, you will learn how to delete all duplicate rows or records from a table in SQL Server

This post explains static and dynamic pivot query in SQL Server

In this blog, I will explain the SQL Cursor.

The commands in this blog will help you to understand the way a table structure can be changed or altered. In this blog, one can find examples related to adding new columns, removing unwanted colum...

This blog post is related to the ALTER command. Whenever we want to change the structure of the table we can use the following commands as mentioned in this blog.

In this blog, I will explain indexes in SQL Server.

In this blog, I will explain SQL View

In this blog, I will explain SQL Triggers.

In this blog, I will explain the SQL Stored Procedure

In this blog, I will explain SQL JOIN Statements. These are used to relate one or more tables in SQL Server

Basics about Data Integrity Constraints. Why and when to use a constraint is explained in this document with respect to Entity Integrity Constraint using Primary Key and Unique constraints.

In this blog, I will explain SQL user-defined functions

In this blog, I will explain the SQL Constraints.

In this blog, I will explain SQL operators. SQL operators are used as arithmetic, logical and bitwise operators.

In this blog, I will explain DDL and DML Commands.

This post explains how to read an XML document using SQL queries.