insert
create procedure stp_insert
@name varchar(50),
@age int,
@dob smalldatetime
as begin
insert into tbl3tier values(@name,@age,@dob)
end
select
create procedure
stp_selectall
as begin
select * from tbl3tier
end
select specific
create procedure
stp_selectcondition
@id int
as begin
select * from tbl3tier where
id=@id
end
delete
create procedure stp_delete
@id int
as begin
delete from tbl3tier where id=@id
end
update
create procedure stp_update
@id int,
@name varchar(50),
@age int,
@dob smalldatetime
as begin
update tb3tier set name=@name,age=@age,dob=@dob where id=@id
end
