SQL Server Trigger After Insert

sql server trigger after insert example

We can fire triggers after an SQL statement to perform a specific task. A trigger is a set of SQL statements defined to perform a specific task you can fire after a certain event. This tutorial will discuss SQL Server trigger after insert with a few examples. The triggers can be created on the tables. … Read more >>

SQL Server check user permissions on database

How to check user permissions in SQL Server management studio

Do you want to check user permissions in SQL Server? In this SQL server tutorial, I will explain to you how to check user permissions on a database in SQL Server. I will also explain, how to check user permissions in sql server management studio, sql query to check user permissions on the database, and … Read more >>

SQL Server Cross Join vs Left Outer Join

In this SQL Server tutorial, we will learn everything about SQL Server Cross Join vs Left Outer Join. SQL Server is a popular relational database management system that provides several types of join operations to combine data from two or more tables. Two commonly used types of join operations in SQL Server are Cross Join … Read more >>

Optional Parameters in SQL Server Stored Procedure

Optional Parameters in SQL Server Stored Procedure

This SQL Server tutorial will illustrate how to create and use the optional parameters in a SQL Server Stored Procedure. When we are not sure if we need to insert data into a particular column or not, we use the concept of optional parameters in a stored procedure in SQL Server. Use of Optional Parameters … Read more >>

Find Stored Procedure by Name in SQL Server

Find Store Procedure in SQL Server by Table Name using Object Explorer image 1

This SQL Server tutorial will teach you how to find the stored procedure in SQL Server by name. Two methods can be used to find stored procedures in SQL Server by using the procedure name. Here are methods which are used are given below. Search Stored Procedure by Name in SQL Server To find the … Read more >>

Select last 10 records in SQL Server without sorting

Select last 10 records in SQL Server without sorting

In this SQL Server tutorial, we will learn how to fetch or select the last 10 records from a table in SQL Server without sorting. Before we see how to fetch the last 10 records in SQL Server without sorting. Here is the image of the EMPLOYEE_ACCESS table which is used in the SQL Server. … Read more >>

Find Store Procedure in SQL Server by Table Name

Find Store Procedure in SQL Server by Table Name

This SQL Server tutorial will teach how to find the store procedure by table name in SQL Server. There are 3 ways to find store procedure names in SQL Server by table name. Here are the methods which we are going to use: Find Store Procedure in SQL Server by Table Name using sys.procedure table … Read more >>

Latest Record for Each User in SQL Server

Latest record for each user in SQL Server

In this SQL Server tutorial, we will understand how to get the latest record for each user from a table in a SQL Server. There are 2 ways to fetch the latest record for each user in SQL Server. And in this tutorial, we will discuss both methods: Here is a sample table: EMPLOYEE_ACCESS which … Read more >>

SQL Server Right Outer Join vs Left Outer Join

SQL Server Right Outer Join vs Left Outer Join

In this SQL Server tutorial, we will understand the difference between the SQL Server RIGHT OUTER JOIN and LEFT OUTER JOIN clauses on tables by the query. In SQL Server, there are different types of JOINS that we can use. RIGHT JOIN and LEFT JOIN are some of the most utilized JOINS in SQL Server. … Read more >>

SQL Server Left Outer Join Multiple Tables

Sql server left outer join multiple tables example

In this SQL Server tutorial, we will learn and understand how to use the SQL Server LEFT OUTER JOIN on multiple tables by query. In one of our previous tutorials on SQL Server Outer Join, we have seen how to use the Outer join on 2 tables in SQL Server. However, there could be a … Read more >>