--上机练习1
declare @sql nvarchar(32)
set @sql='☆'
print @sql
print @sql+@sql
print @sql+@sql+@sql
print @sql+@sql+@sql+@sql
print @sql+@sql+@sql+@sql+@sql
--上机练习2
--查询
declare @age datetime
select @age=Birthday from student where studentNo=23316
declare @name nvarchar(32)
select @name=studentName from student where studentNo=23316
declare @niangling int
set @niangling=floor(datediff(dy,@age,GETDATE())/365)
print '姓名是:'+cast(@name as nvarchar(32))+' 年龄是:'+cast(@niangling as nvarchar(32))
--上机练习3
declare @id int
select @id=subjectid from Subject where SubjectName='java'
declare @cj int
select @cj=studentresult from result where subjectid=@id and studentno=23219
if(@cj>=85)
begin
print '优秀'
end
else if(@cj>=70)
begin
print '良好'
end
else if(@cj>=60)
begin
print '及格'
end
else
begin
print '很差'
end
第一本书 第三章上机练习1-3
最新推荐文章于 2018-12-11 17:48:38 发布