摘要：select CONVERT(varchar, GETDATE(), 120)//当前时间：2019-07-26 08:58:09 select CONVERT(varchar(100), GETDATE(), 23)//当前时间：2019-07-26 select * from Smoke where datediff(day, dateadd(dd,0,addTime),getdate())... 阅读全文

摘要：go create proc usp_dt_managerByPage @pagesize int=10, @pageindex int=1, @recordcount int output, @pagecount int output as begin select * from (select *,rn=ROW_NUMBER() over(order by id asc) ... 阅读全文

摘要：选择：select * from table1 where 范围 插入：insert into table1(field1,field2) values(value1,value2) 删除：delete from table1 where 范围 更新：update table1 set field1=value1 where 范围 查找：select * from table1 where fi... 阅读全文