In this blog I will explain one of the major application in stored procedure that will execute one procedure from another procedure with parameters. Let’s start with creating

Now I need to tell you how to Set Up Managed Backups in SQL Server 2016. It’s very easy and quite nicely documented. Before you will get towards,

The first and most important things in everyone’s mind is, “What are triggers and why we do we use them?” So a trigger is nothing but a special

This is not a new topic. If you search, you may sure realize several posts on this, largely with old techniques however not using newest capabilities like SQL

By default, SQL Server system objects are outlined in Object Explorer in Management Studio. These technique objects embrace system database, system tables/views/procedures etc. SQL Server Management Studio gives