Question: I am new to SQL Server triggers.

Suppose we write an `after insert` trigger for table `tableA` and in that trigger, can we have an `INSERT` operation on the same table i.e `tableA`?

Any suggestions please?

Answer: 
Yes, if you could disable recursive trigger.

```
SP_CONFIGURE 'nested_triggers',0
GO
RECONFIGURE
GO

```
Yes, you can:

**[SqlFiddleDemo](http://sqlfiddle.com/#!6/f19cf/1/0)**

```
CREATE TABLE tab(a INT);

INSERT INTO tab(a) VALUES (1);

CREATE TRIGGER trg_tab ON tab
 AFTER INSERT
AS
   INSERT tab
   SELECT a+1 FROM inserted;

INSERT INTO tab(a) VALUES (10);

SELECT *
FROM tab;

```

Result:

```
a
1
10
11

```