摘要：select (row_number()over(order by dabh)-1)/20[groupby] from v_payroll 阅读全文

摘要：新建一个txt文件，比如我要把我的BMP格式的图片全改成jpg格式的图片，我们就在文档里面写入“ren空格*.jpg空格*.gif"然后保存！ 然后将后缀名改为.bat 阅读全文

摘要：select convert(varchar(10),dateadd(day,number,dateadd(day,-9,getdate())),120) as [date] from master..spt_values where datediff(day,dateadd(day,number,dateadd(day,-9,getdate())),getdate())>=0 and num... 阅读全文