How to Compare SQL Databases and Find Out the Differences

In this tutorial, we will learn how to compare two SQL Server Databases, and find out the differences between the two SQL Server Databases. Let’s assume we have our Students database in UAT and the Production environment, and we suspect that there is some inconsistency between these two database versions. To debug this issue we […]

Exception Handling and Rollback Transaction in SQL Server Stored Procedure


As developers, we often encounter exceptions. What do you do when you encounter an exception in Sql Server? You write a stored procedure to handle the exception! In this article, I will show you how to write a stored procedure that can handle sql server exceptions and rollback the transaction in case of an error […]