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…)
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.
(more…)
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.
(more…)
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.
The following steps explain how to do Full Backup of your database using SSMS.
Click the plus sign in-front of the Databases node. This will show all the databases.
(more…)
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.
(more…)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…)
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.
(more…)