The SQL UNION operator combines two or more SELECT statements.

This example demonstrates how to write and execute dynamic SQL Query in SQL Server. You can execute the Query using EXEC sql command and sp_executesql commands in SQL Server.

In this blog, the user can find out in which table records are deleted or inserted.

ACID properties are atomicity, consistency, isolation, and durability.

SQL Server 2008 R2 setup failed with “Error 1406. Could not write value to key \SOFTWARE. System error. Verify that you have sufficient access to that key, or contact your support personnel”.

This blog will list different ways to use GETDATE() funtion in SQL Server 2008 R2. The major changes in the new SQL Server 2008 are the DateTime function and the introduction of new data types.

In this blog, we will learn how we can merge the table data using merging statement.

SQL Server uses a process called parameter sniffing when it executes a stored procedure that has parameters. When the procedure is compile or recompiled, the value passed in the parameter is evalua...

Usually, we use * to select all the columns but if we have to select all the columns except one column, then we have to write all the required columns one by one. Here I am going to show how we can...

In this blog, I have explained the process involved in the password security using Encryption and Decryption in SQL Stored Procedure.

In this blog, we will learn how to setup AdventureWorks Database in Microsoft SQL Server 2014.

This script will perform bulk insert of images, documents in table.

Bitwise operators in SQL server. Bitwise AND (&) and Bitwise Exclusive OR(^)(Caret symbol use in MS SQL server)

The delete query should delete all duplicate rows except one. The output should be as shown below, after the delete query is executed.

Most of the time, if we have to rename a table or rename a column, we usually drop table and create table again, but with this approach we lose data. This approach may work in a development environ...

This blogs talks about Indexed Views in SQL Server and the pros and cons of using them.

This script will create table definition along with unique key, primary key and indexes.

Using this function, we can get a list of all transactions performed in the database. Function name is fn_dblog() (Formally known as DBCC command).

In this blog, you will learn how to fix the error - "The Instance ID 'MSSQLSERVER' Is Already In Use By SQL Server Instance 'MSSQLSERVER.INACTIVE'.

In this blog, I will demonstrate how to convert a table column in C# model class, using stored procedure.