Applied Knowledge

ASP.NET Core, SQL Server, Excel & Access VBA, JavaScript and SAS

Home

SQL Server Stored Procedures

In this post we will learn what is stored procedure, how it is different from query and what are its advantages over queries. Procedures I...
Excel VBA- ListBox

Objectives To provide detailed information about ListBox Types of ListBox Using ListBox in VBA applications Please read the post till end...
SQL Server ACID Properties of Transaction

ACID Properties To understand transaction in depth, we must know all about its properties. We will look at ACID properties which are rela...