Hi,

In my SQL Server 2000, I want to create an Insert trigger.
If inserting into TableA, then it will also insert into TableB.
What will the solution be like?
Thanks for help.


Jason

Here's a generic skeleton for such a trigger:

CREATE TRIGGER myTrigger ON TableA
AFTER INSERT
AS
IF @@ROWCOUNT = 0 RETURN
INSERT INTO TableB (col1, col2, ...)
SELECT col1, col2, ...
FROM inserted
GO

See Books Online, CREATE TRIGGER for more information.

Show quoteHide quote

problem with BCP
Help
DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
Group by weekends
SQL Monitoring tools...
SQL Express Connection Issues
Idle Sql Agent consumes CPU
SSIS error
Enforcing naming conventions
.BAK extension ??