Category :- Sql Server

Complete Guide: Union all vs Union operators in SQL Server

SQL Server has 2 operators called Union All and Union that combine the result-set of two or more SELECT statements. The difference between Union All and Union operators is that Union All will ‘not remove the duplicate rows’ from the combined result-set, on the other hand Union operator will ‘remove the duplicate rows’ from the combined result-set. (more…)

How to use sp_executesql to Execute Dynamic Statements and Stored Procedures

The sp_executesql statement is used to execute dynamically built T-SQL Statements and stored procedures. It can have both input and output parameters and is very useful in SQL development.

How to Restore Database in SQL Server

If you have the Database Backup File then you can easily restore it to your SQL Server. I will use SQL Server Management Studio (SSMS) to restore the database.

How to Backup SQL Database using SSMS

In this tutorial I will teach you how to Backup SQL Database with your SQL Server Management Studio (SSMS). This will save you from losing your data in case of any SQL Server problem.

SQL Database Backup Steps

The following steps explain how to do Full Backup of your database using SSMS.

STEP 1: Expand the Database node

Click the plus sign in-front of the Databases node. This will show all the databases.

How to Perform CRUD Operations in SQL Server

CRUD Operations stands for Create, Read, Update and Delete, these are the basic functions of any database. In this tutorial I will teach how to perform CRUD in SQL Server.

How to Script Database With All Data From Microsoft SQL Server Management Studio

Sometimes in SQL Server when attempting to restore a database on server A (whose backup is taken on server B) fails due to servers A and B using different versions of SQL server. In such a situation restoring database is done by generating database scripts of both schema and data. (more…)

How to implement Custom Paging with SQL Server using row_number() method

Huge data with paging always causes big headaches to developers. It not only slows down the performance of the application but also takes up lot of resources of the server.

But fortunately you can use the technique of custom paging in your SQL server stored procedure that make your application faster and better.