T-SQL 查询返回每个月的最后一天生成的订单
use tsql2012
select orderid, orderdate, custid, empid
from sales.orders
where month(dateadd(day, 1, orderdate))<> month(orderdate)
T-SQL 查询返回每个月的最后一天生成的订单
use tsql2012
select orderid, orderdate, custid, empid
from sales.orders
where month(dateadd(day, 1, orderdate))<> month(orderdate)