SQL SERVER 学习笔记二

创建数据表

Create Table T_person4(Id int IDENTITY(1,1)  ,Name nvarchar(10),Age int,FIndate datetime,Fsalary decimal(5,2), Primary key(Id))
修改一下表中的字段，刚定义的时候把Fsalary 定义成了decimal了.

Alter Table T_person4 alter column Fsalary numeric(10,2)

增加记录

insert into T_person4(Name,Age,FIndate,Fsalary)values('李大',42,'2010-11-17',5200.2)
insert into T_person4(Name,Age,FIndate,Fsalary)values('李厅',52,'2009-07-21',3240.2)

查询语句

1.select Name as '姓名',Age as '年龄',Fsalary as '月薪' from T_person4
where Fsalary <5000

 

2.select Name as '姓名',Age as '年龄',Fsalary+10000 as '月薪',getdate() as '当前时间' from T_person4

select 可以和表无关

select 1+1
select getdate()

 

数据排序

select * from T_person4
order by Age Asc --升序
select * from T_person4
order by Age Desc --降序

 

select * from T_person4
order by Age Desc,Fsalary ASC--降序,多个条件情况下的查询排序

放在Where后面。