Virtual table in SQL Server

Question

Hi friends I want to know that the name of virtual table does a trigger use? Can we make own virtual table in sqlserver?

Jignesh Trivedi · Answer

hi When a trigger is executed SQL Server creates two virtual tables called INSERTED and DELETED . For example when inserting a recode into a table SQL Server creates a virtual table call INSERTED and loads data into the inserted table then executes the trigger statements and writes the related data pages. One feature of this is joining other tables to the virtual tables. I think we might not create this type of custom virtual table. hope this help.