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…)
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 in your SQL Server Management Studio (SSMS). This will save you from losing your data in case of any SQL Server problem.
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
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…)
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…)