Código SQL:
Ver originalCREATE TRIGGER ShowCustomerInserted ON clientes after INSERT
AS
DECLARE @cliente AS INT
SELECT @cliente=id_cliente FROM inserted
EXEC sp_showcustomer @cliente
Código SQL:
Ver originalCREATE PROCEDURE sp_showcustomer (@cliente AS INT)
AS
BEGIN
SELECT datos FROM cliente WHERE id_cliente=@cliente
END
Continua con lo demas :)