Category :- Sql Server

Using sp_executesql to Execute Dynamic Statements and Stored Procedures

Last Updated: October 10, 2017

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

How to Restore Database in SQL Server

Last Updated: April 3, 2017

restore database 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. (more…)

How to Backup SQL Database using SSMS

Last Updated: March 30, 2017

backup sql database

In this tutorial I will teach you how to Backup SQL Database in 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. (more…)

How to Perform CRUD Operations in SQL Server

Last Updated: February 20, 2017

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. Create = Create a Table / Insert Records into a Table Read = Select Records from a Table Update = Update Records in a Table Delete = Delete Records from a Table

Create a Student Table

I will first create a Student Table where I will perform CRUD Operations. This table contains the information of students in a School. In the Object Explorer of SQL Server right click on the Databases node and select New Database. (more…)

Script Database With All Data From Microsoft SQL Server Management Studio

Last Updated: October 8, 2016

Script Database

Sometimes in SQL Server 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. So in this case we Script Database in server B and then run these scripts on database in server A. This SQL Script contains all the Schema with Data. So we can simply run this SQL Script in Server A database and our original database is recreated. (more…)

Custom Paging with SQL Server 2012

Last Updated: March 21, 2017

Custom Paging SQL Server

Huge data with paging always causes big headaches to developers. It not only slows down the performance of our 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 and make your application faster and better. (more…)