摘要: 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 阅读全文
posted @ 2013-04-24 11:25 放哨De老鼠 阅读(855) 评论(0) 推荐(1) 编辑