p05LqHMx

1USE tempdb;
2GO
3
4CREATE TABLE dbo.SmellThis
5(
6  id INT IDENTITY(1,1),
7  name VARCHAR(32)
8);
9GO
10
11CREATE TRIGGER dbo.SmellThis_First
12ON dbo.SmellThis
13INSTEAD OF INSERT
14AS
15BEGIN
16    SET NOCOUNT ON;
17
18    DECLARE @ids TABLE(id INT);
19
20    IF NOT EXISTS 
21    (
22      SELECT 1 FROM sys.objects AS o
23        INNER JOIN inserted AS i
24        ON o.name = i.name
25    )
26    INSERT dbo.SmellThis(name)  
27      OUTPUT inserted.id INTO @ids
28      SELECT name 
29      FROM inserted;
30
31    SELECT id FROM @ids;
32END
33GO
34
35INSERT dbo.SmellThis(name) SELECT 'Remus';
36GO
37	
38id
39----
401
41	
42DROP TABLE dbo.SmellThis;
43	
44SELECT * FROM deleted UNION ALL
45SELECT * FROM inserted;
46	
47SELECT IDENT_CURRENT(‘tablename’) AS <IdentityColumnname>