1 更新特定表中记录的存储过程并在WEBpage中使用ADO调用。
use School
select * from T_Class
create proc usp_Class_update
@Cid int,
@Cname varchar(50)='Net',
@cDes varchar(50)='好班!'
as
begin
update T_Class set FclsName=@Cname,FclsDiecription=@cDes where Fclsid=@Cid
end
--实验
exec usp_Class_update 1,'3G','恩??'
2 写一个查询表中记录的存储过程,并在winform中应用他实现显示student表中的所有记录(app.config,引用,ClassModel类,List泛型绑定,dataGradView1的数据源)。
create procedure usp_class_selectAll
as
begin
select * from T_Class
end
exec usp_class_selectAll
3 写一个对特定表进行分页显示的存储过程,要求有两个参数一个是 每页显示的记录的条数(@pagesize),第二个是显示第几页(@pageIndex)
use TextSchool
select * from T_Student
create proc usp_MyStudent_GetDateByPageIndex
@pageSize int=5,
@pageIndex int
as
begin
select * from
(select *,ROW_NUMBER() over(order by Fstuid) as rowIndex
from T_Student)as tbl
where tbl.rowIndex between(@pageSize*(@pageIndex-1)+1) and (@pageSize*@pageIndex)
end
exec usp_MyStudent_GetDateByPageIndex 3,3
4 使用存储过程、事务、webpage实现转账。
思路1要有存储过程,存储过程中包含事务。参数应该有3个(转入账号,转出账号,金额)
update bank set ammonut=amonut-金额 where id=转出账号
update bank set ammonut=amonut+金额 where id=转入账号
create proc usp_bank_trans
@outputNumber int,
@inputNumber int,
@moneyNumber money
as
begin
begin tran
begin try
update bank set ammonut=amonut-金额 where id=转出账号
update bank set ammonut=amonut+金额 where id=转入账号
commit
end try
begin catch
rollback
end catch
end