sql

Steps to connect Azure SQL with Azure Active DirectoryCreate an Azure SQL DatabaseConfigure it to use Azure AD by setting up an adminCreate a Managed IdentityCreate an App Service and enable system…

Let's assume you want to loop through a table variable having a structure like below. DECLARE @tempCategories TABLE ( Id INT, CategoryName NVARCHAR(500),)Now, to iterate through this table, just add…