T-SQL学习笔记

学习T-SQL时记载的笔记，记得其实不全也不详细
!-- more --

if和while语句

declare @age int
select @age = DATEDIFF(year,stuAge,getdate()) from TbStudent where stuName = "孙悟空"

if(@age>=18)
begin --必需有begin..end
    print N"已成年"
end
else
begin
    print N"未成年"
enddec