I wish to write a trigger in SQL Server to place 2 rows into table2 whenever a row is placed into table1. I wish to make use of a column value from table1.

So my trigger appears like this

create trigger triggername on table1
as
begin
insert into
insert into
end

How do you get the need for any column in the last placed row (the row insertion which fires the trigger). I.e. the same as 'referencing row' in oracle

Triggers in SQL Server fire per statement not per row. You will find two pseudo tables inserted and deleted which you can use (to have an insert trigger the only person of great interest is inserted)

CREATE TRIGGER YourTrigger ON Table1
FOR INSERT
AS
INSERT INTO Table2 
SELECT * from inserted /*This will contain multiple rows if it is a multi-row insert*/

hi i've the answer myself. i skipped the alias

choose @patient_no=fldL1BasCode from placed

ought to be

choose @patient_no=i.fldL1BasCode from placed i