Nada

Páginas: 11 (2543 palabras) Publicado: 18 de mayo de 2013
create database Taller;
use Taller;
----------------------------------------
create table Dato (
Id int primary key,
Num float not null
);
insert into Dato values (1,10);
insert into Dato values (2,2.31);
insert into Dato values (3,42.1);
insert into Dato values (4,0.6);
insert into Dato values (5,9.0);
insert into Dato values (6,-1);
insert into Dato values (7,0.5);
insert intoDato values (10,0);
-----------------------------------------
select * from Dato;
drop table Dato
----------------------------------------
create trigger Actu_Asin
on Dato for update as
declare @Num as float
begin print 'El arcoseno del numero actualizado es:'
select @Num = (select Num from updated)
select @Num = (select asin(@Num))
print @Num
end
update Dato set Num=0 whereId=10;

drop trigger Actu_Asin
--------------------------------------------
create trigger Eliminar_Asin
on Dato for delete as
declare @Num as float
begin
print 'El arcoseno del numero eliminado es:'
select @Num = (select Num from deleted)
select @Num = (select asin(@Num))
print @Num
end

delete from Dato where Id=4;



----------------------------------------------
createtrigger Insertar_Asin
on Dato for insert as
declare @Num as float
begin
print 'El arcoseno del numero insertado es:'
select @Num = (select Num from inserted)
select @Num = (select asin(@Num))
print @Num
end

insert into Dato values (12,0.5);

-----------------------------------------------
create trigger Actualiza_Atan
on Dato for update as
declare @Num as float
begin
print'El arcotangente del numero actualizado es:'
select @Num = (select Num from updated)
select @Num = (select atan(@Num))
print @Num
end
update Dato set Num=-1 where Id=9;
------------------------------------------------
create trigger Eliminar_Atan
on Dato for delete as
declare @Num as float
begin
print 'El arcotangente del numero eliminado es:'
select @Num = (select Num fromdeleted)
select @Num = (select atan(@Num))
print @Num
end

delete from Dato where Num=0.5;


------------------------------------------------
create trigger Insertar_Atan
on Dato for insert as
declare @Num as float
begin
print 'El arcotangente del numero insertado es:'
select @Num = (select Num from inserted)
select @Num = (select atan(@Num))
print @Num
end
insert into Dato values(14,-0.3);

-----------------------------------------------aca
create trigger Actualizar_Acos
on Dato for update as
declare @Num as float
begin
print'El arcocoseno del numero actualizado es:'
select @Num = (select Num from updated)
select @Num = (select acos(@Num))
print @Num
end
update Dato set Num=0 where Id=10;
------------------------------------------------
create triggerEliminar_Acos
on Dato for delete as
declare @Num as float
begin
print 'El arcocoseno del numero eliminado es:'
select @Num = (select Num from deleted)
select @Num = (select acos(@Num))
print @Num
end
delete from Dato where Num=-0.3;

------------------------------------------------
create trigger Insertar_Acos
on Dato for insert as
declare @Num as float
begin
print 'El arcocoseno delnumero insertado es:'
select @Num = (select Num from inserted)
select @Num = (select acos(@Num))
print @Num
end
insert into Dato values (12,-0.3);


------------------------------------------
------------------------------------------
------------------------------------------

create table Palabras (
Id int not null primary key,
Nombre varchar(4000)
);
insert into Palabrasvalues(1,'Odio las papas fritas');
insert into Palabras values(2,'Ayer hiz calor Calor');
insert into Palabras values(3,'Frio');
insert into Palabras values(4,'');
insert into Palabras values(5,'Que fio hace ');
select * from Palabras;

-------------------------------------------
create trigger Actualizar_Patindex
on Palabras for update as
declare @nombre as varchar(4000)
declare...
Leer documento completo

Regístrate para leer el documento completo.

Estos documentos también te pueden resultar útiles

  • la nada de nada
  • nada de nada
  • nada de nada
  • nada de nada
  • no se nada nada nada
  • Nada nada nada
  • Nada de nada
  • Nada de Nada

Conviértase en miembro formal de Buenas Tareas

INSCRÍBETE - ES GRATIS