WEB LISTING 1: Solution 1

-- Revised trigger
-- In SQL Server 6.5 drop and recreate the trigger
ALTER TRIGGER trg_i_Orders_logorder ON Orders FOR INSERT
AS

IF OBJECT_ID('tempdb..#TmpIdent') IS NOT NULL
  INSERT INTO #TmpIdent VALUES(@@identity)

INSERT INTO LogOrders(orderid, customerid, orderdate)
  SELECT * FROM inserted
GO

-- revised script
DECLARE @neworderid AS int

CREATE TABLE #TmpIdent(ident int NOT NULL)

INSERT INTO Orders(customerid, orderdate)
  VALUES(1001, GETDATE())

SELECT @neworderid = ident
FROM #TmpIdent

DROP TABLE #TmpIdent

INSERT INTO OrderDetails(orderid, partid, qty)
  VALUES(@neworderid, 101, 10)
INSERT INTO OrderDetails(orderid, partid, qty)
  VALUES(@neworderid, 102, 10)
INSERT INTO OrderDetails(orderid, partid, qty)
  VALUES(@neworderid, 103, 10)