Month: December 2018

Azure – Creating an Azure SQL Database

vivekjohari29 Comments on Azure – Creating an Azure SQL Database

Creating an Azure SQL Database Contents Introduction Creation of Azure SQL Database Step 1: Select Database Name Step 2: Select Azure Subscription Step 3: Choose Resource Group Step 4: Choose Database Source Step 5: Choose SQL Server Step 6: Choose Elastic Pool Option Step 7: Choose Service Tier for database Step 8: Deployment of Azure […]

Continue Reading

SQL Triggers – An Introduction

vivekjohari33 Comments on SQL Triggers – An Introduction

SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax of the After trigger Example of After Trigger for Insert Example of After Trigger for Delete Example of After Trigger for Update Instead of Triggers DDL Triggers DDL Trigger for Create Table DDL Trigger for […]

Continue Reading