Unos ejercicios...

[torsku]

create procedure showcustomer
as
select nombre+" "+apellidos, direccion, email, phone, ‘cliente insertado’
from inserted

create trigger showcustomerinserted
on bank.clientes for inserted
as
exec showcustomer


asi mejor??