Category :- Sql Server

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: February 12, 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…)