SQL Server 2008 Create Trigger after insert... return id... called stored procedure -

SQL Server 2008 Create Trigger after insert... return id... called stored procedure -

i want simple sql server trigger (after insert) id table inserted into... algorithm:

new record inserted table

trigger called

trigger takes id inserted record , called stored procedure

my failed effort below:

create trigger [dbo].[insertnewmarket] on [dbo].[markets] after insert begin declare @marketid int set nocount on; --select id inserted --set @marketid = inserted.id--get inserted id , pass stored proc exec marketinsert @marketid end go

create trigger [dbo].[insertnewmarket] on [dbo].[markets] after insert as begin declare @marketid int set nocount on; select @marketid = id inserted exec marketinsert @marketid end go

sql sql-server sql-server-2008 stored-procedures