Trigger in SQL Trigger in SQL. After learning about Stored Procedures in our last article. Its time to talk about Triggers in SQL. The concept of triggers is very powerful provided by Microsoft because it is related to the security of data. A trigger simply means a button. Behind every
Stored Procedures Stored Procedures in SQL is an amazing feature provided by Microsoft in SQL. This is the feature that you will find yourself using a lot when you start developing web applications, and reports. Stored Procedure has several names like proc, storp, sproc, stopro, StoredProc, sp. The stored proc
Computed Column in SQL The computed columns in SQL is a concept of filling calculated data in a column. Suppose have a table in which the first name and the last name columns exist but you need a column where you need both first name and last name in a
What are the Views in SQL Views in SQL. This is my way of understanding concepts in the study. Whenever I want to understand a function or a concept or anything, I try to understand the need for that concept. I would like to do the same thing here and
Important SQL Queries. We will be discussing some important queries in this article with their examples because we have already set up the Adventureworks database. Before we start talking about the SQL Queries, we need to know some things about SSMS and how to use it. Parts of SSMS First
What is the Adventureworks Database Adventureworks Database is a waxwork database that is designed by Microsoft. Microsoft provided it for developers who want to practice SQL queries and they don’t have real databases. This is very challenging to form a database that is huge and complex enough that we
SQL Server Installation SQL Server Installation. After discussing what is a database and its queries. Let’s install the SQL Server and SQL Server Management Studio. We need to first set up the SQL server. I can tell you all the software you need to download and install. You need
What is Database Query? Earlier we have talked about what is data and what is a database. Now is the time to discuss what is a database query. So let’s begin. Before we start talking about database query, first we need to understand why we need to database query.
What is Database? If you will start searching on the Internet about the definition of a database, you will find a lot of diverse definitions. Since you are a beginner, I will make it simple for you. I think first you need to understand what is data and then we
Comparison Operators or Relational Operators Just like Arithmetic Operators, we also have comparison operators or Relational Operators. These are just two names of the same thing. The comparison operators compare two operands and return a boolean value (True or False). Just like you see two posters and compare them if
Arithmetic Operators What is Arithmetic Operator in C# are called Binary operators because they work with two operands, we need to place the operator between the operands. For example, when we want to add two numbers, we use the plus (+) operator between the numbers that we want to add. The
Escape Sequence What is Escape Sequence in C#? The escape sequence is a way of writing our statements in such a way that shows up differently on the screen (Console or Windows Form or Website). If we might already know that if we want to print a string then we