1、局部变量
use Xk
Go
declare @xb char(2),@sr datetime //声明两个局部变量
set @xb='女' //赋值
set @sr=1/01/23
select * from Seller where sex=@xb and birthday>=@sr //查询
2、运算符
+ - × / %
3、比较运算符
= > < >= <= <> != !< !>
4、逻辑运算符
ALL
AND
ANY
BETWEEN
EXISTS
IN
LIKE
NOT
OR
SOME
5、函数
use Xk
Go
create function total(@expr1 as int ,@expr2 as int) //声明函数
returns int //返回类型
begin
declare @my_total int //函数主体
select @my_total=@expr1+@expr2
return @my_total
end
Go
select dbo.total(10,20) as 两数之和
use Xk
Go
declare @xb char(2),@sr datetime //声明两个局部变量
set @xb='女' //赋值
set @sr=1/01/23
select * from Seller where sex=@xb and birthday>=@sr //查询
2、运算符
+ - × / %
3、比较运算符
= > < >= <= <> != !< !>
4、逻辑运算符
ALL
AND
ANY
BETWEEN
EXISTS
IN
LIKE
NOT
OR
SOME
5、函数
use Xk
Go
create function total(@expr1 as int ,@expr2 as int) //声明函数
returns int //返回类型
begin
declare @my_total int //函数主体
select @my_total=@expr1+@expr2
return @my_total
end
Go
select dbo.total(10,20) as 两数之和