一、在T—Sql中使用变量
(一)局部变量
1声明变量 @age和@name
declare @name varchar(20)
declare @age int
2赋值
--(1)方法1
set @age=18
set @name='yqq'
--(2)方法2
select @age=27
select @name='ydx'
3分别使用set和select 为行号变量@rcount赋值
declare @rcount int
set @rcount=(select COUNT(*) from Student)
select @rcount=COUNT(*) from Student
计算score表中english平均成绩,如果〉=60,查询正数前三名,否则找出倒数前三名。
declare @count int
select @count=COUNT(*) from Score
declare @sum float
select @sum=SUM(ENGLISH) FROM Score
declare @avg float
set @avg=(@sum/@count)
if @avg>=60
begin
select top 3 * from Score order by english desc
end
else
begin
select top 3 * from Score