SQL Server

We can retrieve data from more than one tables using the JOIN statement. There are mainly 4 different types of JOINS in SQL server. We will learn all JOINS in SQL server with examples: INNER JOIN/simple join LEFT OUTER JOIN/LEFT JOIN RIGHT OUTER JOIN/RIGHT JOIN FULL OUTER JOIN INNER JOIN This type of SQL server…

What is Substring()? Substring() is a function in SQL which allows the user to derive substring from any given string set as per user need. Substring() extracts a string with a specified length, starting from a given location in an input string. The purpose of Substring() in SQL is to return a specific portion of…

Overview of Case in real life! Again, in real life, we perform different actions depending upon the outcome of different conditions. To elaborate more, consider below example: If flight tickets are less than $100, then I will visit Los Angeles. If flight tickets are between $100 to $200, then I will visit New York If…

Why do you need Conditional Statements? Conditional statements in the SQL server help you to define different logics and actions for different conditions. It allows you to perform different actions based on conditions defined within the statement. In real life, you perform many actions dependent on the outcome of some other activity or situation. Some…

What is a FOREIGN KEY? A Foreign Key provides a way of enforcing referential integrity within SQL Server. In simple words, foreign key ensures values in one table must be present in another table. Rules for FOREIGN KEY NULL is allowed in SQL Foreign key. The table being referenced is called the Parent Table The…

What is Primary Key in SQL? Primary Key is a field or a combination of fields that identify a record uniquely. The Primary key is a column or set of columns that are unique. In other words, every value is unique for Primary Key. Rules for Primary Key Each table can have only one SQL…

What is a Table? A Table is an object which stores data in Row & Column format. Below Diagram, shows Rows and Column respectively. Table Rows and Column How to Create a Table in SQL Server with T-SQL The first step to store data in the database is to create a Table where data will…

What is a Variable in SQL Server? In MS SQL, variables are the object which acts as a placeholder to a memory location. Variable hold single data value. Variable Types in SQL: Local, Global MS SQL has two types of variables: Local variable Global variable. However, the user can only create a local variable. Below…

What is Data Type? A Data Type in SQL server is defined as the type of data that any column or variable can store. It is a type of data that an object holds like integer, character, string, etc. While creating any table or variable, in addition to specifying the name, you also set the…

What is Database? A Database is a collection of objects such as tables, views, stored procedures, triggers, functions, etc. Consider a with a few examples in real life: We have Bookcase where Books resides, We have homes where we live, We have parking lots where vehicles are parked & examples are countless. Similarly, we have…