use DB_SPED
go
create table Teste
(
Id int identity primary key,
Name varchar(25) not null,
Dtnasc date not null

)


select * from Teste

insert into Teste (Name, Dtnasc) values( 'Jean4', '1981-12-18') --GETDATE())

use DB_SPED

go
create Procedure AddTeste

@id int,
@Name varchar( 25),
@dtNasC date
as
begin
insert into Teste (Name, Dtnasc) values(@Name , @dtNasC)
end


exec AddTeste 1, 'greg','2000-12-05'
go

Create Procedure getAll
as

begin

select * from Teste
end


exec getAll

go


create procedure UpdateROWS
@ID INT,
@NAME VARCHAR(25),
@DTNASC DATE
AS
BEGIN

UPDATE Teste  SET Name=@NAME, Dtnasc=@DTNASC WHERE Id=@ID

END


SELECT * FROM Teste
GO

EXEC UpdateROWS 2," JEAN JOSEPH","2015-09-19"
go

create procedure FindById
@id int
as
begin
SELECT * FROM Teste
where id=@id

end


exec  FindById 4
go

select top 1 * from teste
order by Id desc