机房SQL语句总结

一、查询

Select username from T_User where level='操作员'                     ---------查询表中一个字段

select * from T_User where UserID=@UserID                                 ---------查询表中是否有相同

Select top 1 Rate,VipRate,LimitCash From T_BasicData                 ---------查询一行数据

select sum(Cash) as 'Cash' from T_LineLog where Ischeck= '未结账'------查询一个字段的总和

select CardNo,UserID,UserName from T_ReCharge where  RechDate Between @RechDate+' 00:00:00.000' and @RechDate+' 23:59:59.000'

                      ---------时间截取

SELECT * FROM[T_Recharge] WHERE CardNo like @CardNo         ---------模糊查询

 

二、插入

Insert Into T_User values(@UserID,@PWD,@Level,@UserName,@state)

 

三、删除

Delete from T_User where UserName=@UserName

四、更新

Update T_BasicData set DateTime=@DataTime

UpDate T_User set PWD=@PassWord where userID=@UserID

UpDate T_LineLog set IsCheck='结账' where IsCheck='未结账'