摘要:
--上周数据 datepart(week,AddDate)跨年会有问题SELECT * FROM UsersWHERE datepart(week,AddDate)=datepart(week,getdate())-1 --上月数据 SELECT * FROM Users WHERE datedif... 阅读全文
摘要:
新浪的IP地址查询接口:http://int.dpool.sina.com.cn/iplookup/iplookup.php?format=js新浪多地域测试方法:http://int.dpool.sina.com.cn/iplookup/iplookup.php?format=js&ip=12.1... 阅读全文