The name of the database where the specified table resides. The following example creates a table with an identity column and shows how the SET IDENTITY_INSERT setting can be used to fill a gap in the ...
The TOP expression doesn't affect statements that might run because of a trigger. The inserted and deleted tables in the triggers return only the rows that are truly affected by the INSERT, UPDATE, ...