数据库课程设计-银行存储管理系统

select @Savestyle=Savestyle from insertedРif (@Savestyle='定期三年' and @Savetime <3)РbeginРprint '储蓄时间不足年,无法取款'Рrollback transactionРendРelse РifР(@Savestyle='定期五年' and @Savetime <5)РbeginРprint '储蓄时间不足年,无法取款'Рrollback transactionРendР余额不足触发器:РCreate trigger [dbo].[T3] on [dbo].[UserSavemessage] for updateРasРdeclare @allmoney moneyРselect @allmoney=allmoney from insertedРif (@allmoney <1)РbeginРprint '余额不足!'Рrollback transactionРendР存储过程:Р添加管理员存储过程:Рcreate procedure [dbo].[AdminAdd]Р?(@AdNumber [varchar](50),@AdName [varchar](50), @AdPassword [varchar](50) Р?)Рas insert into [admins]Р?(AdNumber,AdName,AdPasswordР?)РvaluesР?(@AdNumber,@AdName,@AdPasswordР?)Р删除管理员存储过程:Рcreate procedure [dbo].[Admindelete]Р?(@AdNumber [varchar](50) Р?)Рas delete [admins]Рwhere([AdNumber]=@AdNumber)Р修改管理员信息存储过程: