hi,
i read the article,trigger too is created but at run time error occurs.
It is returning error something like :

Subquery returnes more than 1 value.This is not permitted when the subquerry follows=,!=,<,..... or when the subquery is user as an expression.


My Trigger Body is:

ALTER TRIGGER Trigger1
ON dbo.sal_t
FOR INSERT
AS
begin
declare @id1 int
set @id1=(select id from sal_t)
insert into emp_t values(@id1,'ram')
end


TABLE SCHEMA ARE:
Table- sal_t:
id int,
sal int

Table- emp_t
id int,
name varchar(20)

so,where i am wrong??