Category Archives: Most Imp SQL Concepts

This category contains the most important SQL Concepts

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 … Continue reading

Posted in Most Imp SQL Concepts, SQL Advanced, SQL Server, SQL Triggers | Tagged , , , , | 33 Comments

Exception handling in SQL Server

SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write the SQL Statements within the Try block and if any exception occurred control automatically goes to the group of SQL … Continue reading

Posted in Most Imp SQL Concepts, SQL Server, SQL Server Exception handling | Tagged | 31 Comments

Case Statement/ Expression in SQL Server

Case Statement/ Expression in SQL server  Sometimes we need to get one result output from multiple possible outcomes based on the evaluation of some expression. This expression can be a simple case expression which compares an expression with a set … Continue reading

Posted in Most Imp SQL Concepts, SQL Basic Concepts, SQL Server | Tagged , | 1 Comment

Pivot and Unpivot table in SQL SERVER

Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means of aggregating the values. Pivot table can be used if we want to display the unique values of the column of … Continue reading

Posted in Most Imp SQL Concepts, SQL Pivot and Unpivot table, SQL Server | Tagged , | 25 Comments

CTE command In Sql Server

Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by the execution of the query (insert, delete, update, select or update view statement). It is not stored as an object … Continue reading

Posted in Most Imp SQL Concepts, SQL CTE, SQL Server | Tagged , | 31 Comments

SQL Server Functions- An Introduction

SQL FUNCTION: – Function in a database can be defined as the code segment consisting of a logical group of SQL statements which takes some input arguments (if required), run in a sequential order and returns the output either in … Continue reading

Posted in Most Imp SQL Concepts, SQL Functions, SQL Server | Tagged , , | 31 Comments

Cursor in SQL server

Sometimes our application required a database object which allows manipulation of data from a set of rows on row by row basic which means single row at a time. Cursor is the database object which solves this problem. With the use of … Continue reading

Posted in Most Imp SQL Concepts, SQL Cursor, SQL Server | Tagged , , | 33 Comments

Sql Server View

Views:- View can be described as virtual table which derived its data from one or more than one table columns.It is stored in the database. It is used to implements the security mechanism in the Sql Server. For example, suppose … Continue reading

Posted in Most Imp SQL Concepts, SQL Server, SQL View | Tagged , , | 31 Comments

Indexes in Sql server

Indexes-Indexing  is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the table.It can be compared with the index which we use in the book to search a … Continue reading

Posted in Most Imp SQL Concepts, SQL Indexes, SQL Server | Tagged , | 25 Comments

Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins

I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types of Joins in SQL Server are and how they can be best used then they really enjoy using them. By … Continue reading

Posted in Most Imp SQL Concepts, SQL Joins, SQL Server | Tagged , , | 33 Comments