临时表

来源:互联网 发布:李炎恢php视频教程 编辑:程序博客网 时间:2024/06/10 08:51
select userid into #temp_buypeople from (
select distinct userid from dbo.cardlog
where  status=1 and  DATEPART(wk,ADDTIME-1) =DATEPART(wk,GETDATE()-1) ) as buypeople
0 0