用SQL SERVER 2000 编写

来源：百度知道 编辑：UC知道 时间：2024/05/26 17:54:54
用SQL SERVER 2000 编写:利用存储过程，计算每个学生的年龄，将其放在一个新表“学生年龄表”中。求程序 谢谢 急!!!

3. 编写触发器完成简单的完整性检查
1) 检查“学生基本信息”表中的“学号”为5位数字字符
2) 检查“学生基本信息”表中的“电子邮件”中的“@”符号前后有字符串
3) 检查“考勤表”中“学号”来自“学生基本信息”表
这个很简单的 大家快点啊!

"写什么代码你自己看 "??????????????我要能自己看我还问啥啊

create procedure CalAge
(
@StudentID INT
)

as

declare @Age int

set @Age = ( select [Age] from [StudentInfo] where [StudentID] = @StudentID )

insert into [StudentAge] ( [StudentID] , [Age] ) values ( @StudentID , @Age )

create trigger OnStudentInsert
on [StudentInfo]

for

insert

as

declare @NumberLength int , @Email as varchar ( 1000 )
select @NumberLength = len ( [Name] ) , @Email= [Email] from inserted

if ( @NumberLength <> 5 )
delete from [StudentInfo] where [StudentID] = @StudentID
else if ( charindex ( '@' , @Email ) <= 0 )
delete from [StudentInfo] where [StudentID] = @StudentID
else if ( not exists ( select * from [考勤表] where [StudentID] = @StudentID
delete from [StudentInfo] where [StudentID] = @StudentID

你的题目太难了，我给你一个建议吧！你的三个条件可以在客房端用java