摘要:
with temp as(select *From tb_order where Auditing=2 and AuditingTime>='2013-04-01' and Flag=2)select *from temp where EbayAccountID=21 相当于临时表 temp 分析器可以智能提示 临时表却不能。临时表select * into #temp From tb_order where Auditing=2 and AuditingTime>='2013-04-01' and Flag=2select * From #temp 阅读全文