Sql sever命令积累

#筛选当天更新数据，并通过Rank排序
select *from table where DATEDIFF (dd,FDate,GETDATE())=0 order by Rank 
#筛选当天更新数据，并通过Rank倒序
select *from table where DATEDIFF (dd,FDate,GETDATE())=0 order by Rank desc     
#修改值
update tableset Rank = 0.573 where ID = 48353     
#增加列
alter table A add B VARCHAR(50)